: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 I am.
I tried the SELECT TO_UNIXTIME(your_column) FROM
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