problem in strtotime with dtabase, need help.

[homer_favenir]

hi,
i need help here
this is my syntax

$new_date = date("m/d/Y", strtotime($datestring));

in php it is ok...but when $new_date is stored in database, it becomes 0000:00:00

what seems the problem?
the databse or the php script?

thanks in advance
😕

[bradgrafelman]

What column type are you storing the value in?

If it a MySQL DATE column (as it appears it should be), you must enter dates using the YYYY-MM-DD format.

[roscor]

I have my database column set as datetime 0000-00-00 00:00:00 by default. when in putting a date in my case the current date and time i use NOW(), then when I recover the info on a select i convert it to my needs

<?php
$date=mysql_result($result,$i,"date");
$ts = mktime(0,0,0,substr($date,5,2),substr($date,8,2),substr($date,0,4)); // Convert to unix format
$formatted = date('d-m-Y',$ts);
?>
//echo out the formatted as i wish.
<input type="hidden" size="" value="<? echo $formatted; ?>

or you could use date-select-format
date-and-time-types
datetime

[bradgrafelman]

Note that it'd be much simpler to just use MySQL's DATE_FORMAT() function.