View Single Post
  #1 (permalink)  
Old 12-20-2006, 02:14 PM
Kut
 
Posts: n/a
Default MySQL dialect question:

How do I format mySQL date?


I have a forum and would like to run a query where I can get the member id, topic id and date that it was read. I am able to do this but the date comes out in an unreable 10 digit number. How do I run the query so it reads as a regular date>

Below, I am looking for topic id 5160 to see all the member ids who read it and the dates.

SELECT 5160, read_mid, read_date FROM ibf_topics_read
Edit/Delete Message Reply With Quote

ANSWER(S):