Menu
Community /Pin to ProfileBookmark
@NogDogMar 17.2008 — #Can you show us what you have tried? I can see no reason why the MySQL DATE_FORMAT() function could not do it, assuming the date/time is stored in an appropriate column type.
If you really, really feel you must do the conversion on the PHP side, look at the[url=http://www.php.net/strtotime]strtotime[/url] () function to convert the string to a PHP UNIX time integer, then use that value with [url=http://www.php.net/date]date[/url] () to get the desired format.
MySQL Timestamp into PHP Format
I have a timestamp column in a mysql table.
Using PHP, how do I convert the timestamp format which is “YYYY-MM-DD HH:MM:SS” into a format like “March 16 2008, 08:41 am” ?
Please help
Thanx
Sign in
to post a comment5 Comments(s) ↴
0
@NogDogMar 17.2008 — #Can you show us what you have tried? I can see no reason why the MySQL DATE_FORMAT() function could not do it, assuming the date/time is stored in an appropriate column type.If you really, really feel you must do the conversion on the PHP side, look at the