Create datetime with specific time mySql
<p>I'm looking to create a date time field in a MySQL script that has a specific date and time.</p>

<p>I've tried using
<code>CONCAT(DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 9 DAY) ,'%Y%m%d'), ' 13:00:00')</code>
but it doesn't insert correctly.</p>

<p>How can I achieve this so that it will insert a date time with the time as above?</p>

<p>It inserts the record as <code>0000-00-00 00:00:00</code> with the above</p>