Posted: Fri Apr 21, 2006 5:47 pm
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