MySQL Timestamp into PHP Format

[cancer10]

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

[Xnuiem]

That is a date column, not timestamp. And sadly enough, that means just a little more work for you.

There are two ways to do this, one is using PHP. You can use the function mktime() (PHP: mktime - Manual) to plug in your output and use date() to get the exact format you want.....

Or, just use MySQL to do it. (MySQL :: MySQL 5.0 Reference Manual :: 11.6 Date and Time Functions)

So you will do something like:

select date_format('<FORMAT YOU WANT>', date_column_name) from table etc....

[hoopyfrood]

Hi cancer10,

I'd recommend you use date() function, do not forget to convert the MySQL timestamp into PHP readable format using strtotime().

I normally use

PHP Code:

date('d/m/Y', strtotime($some_array['my_timestamp)) 


Hope it helps,