Page 2 of 2

Posted: Fri Apr 21, 2006 5:47 pm
by timvw
If you store the datetime as an INT (unixtime) you can still use the DATE_FORMAT function...

Code: Select all

SELECT DATE_FORMAT(FROM_UNIXTIME(datecolumn)), '%H %k %I %r %T %S %w') AS nicedate
FROM somecolumn

Posted: Fri Apr 21, 2006 6:20 pm
by bruceg
I am getting closer. I played around in PHPadmin and now I am able to produce a timstamp like.

Last Update: 20060421173825

my question now is how to get that into a more human readable format.

thanks