View Single Post
  #2 (permalink)  
Old 12-20-2006, 05:20 PM
ben ben is offline
Administrator
 
Join Date: Mar 2007
Posts: 91
ben has disabled reputation
Default MySQL answer. Re: How do I format mySQL date?

I think your date is stored as a UNIX timestamp. MySQL has functions to convert this to 'normal' date formats. See http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html for more info.

[sql]
SELECT read_mid, FROM_UNIXTIME(read_date) as read_date FROM ibf_topics_read WHERE id = 5160
[/sql]
Reply With Quote