March 24, 2003 7:34 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] mysql timestamps
>
> I hope you don't mind me bothering you like this but you seem to know
what
> you're talking about, you replied to my post on php.db in case you are
> wondering who the heck
> how do i change the format of a MySQL timestamp (i.e hh:mm:ss
DD/MM/
> instead of MMDDhhmmss) retrieved from a mysql database with php?
Use
SELECT TO_UNIXTIME(your_column) FROM table ...
And then use date() in PHP to format the result to your liking.
Or, you can use DATE_FORMAT() in y
