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
|