SOLVED: RE: [PHP] storing date in datetime column

WORKS PERFECT! Thanks Brad! -afan > afan@afan.net wrote: >> hi, >> $date = "January 8 2007 11:23 pm"; >> and have to store it on db in datetime column as yyyy-mm-dd HH:ii:ss. >> Is there any function that will "translate" $date in format I >> need to store it in DB? >> >> Right now I was thinking to do like this: >> >> $date_new = explode(' ', $date); >> switch($date_new[0]) >> { >> case 'January': >> $month = '01'; >> break; >> >> case 'February': >> $month = '02'; >> break; >> >> // etc. >> } >> >> $date_time = explode(':', $date_new[3]); $hours = >> ($date_new[4] == 'pm') ? ($date_time[0] + 12) : $date_time[0] >> ; $time_new = $hours.':'.$date_time[1].':00'; >> >> $date_final = $date_new[2].'-'.$month.'-'.$date_time[1].' >> '.$time_now; >> >> Is there better solution than this above? >> >> Thanks. >> >> -afan > > > strtotime() will convert your date string into a unix time format (int) > > Then you can use the date() function to format it properly. Make sure the > date value is enclosed in quotes (like a text string) when inserting into > your database. > > Example: > > $date = "January 8 2007 11:23 pm"; > $mysqldate = date("Y-m-d H:i:s", strtotime($date)); > > $query = "INSERT INTO datefield VALUES > '$mysqldate'"; ... > > Hope that helps, > > Brad > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >