Check Latest Date

[cheeyim]

Hie,
Can anyone tell me how do I check the latest date from an existed database? I know how to retrieve them from database but just need to know how to retrieve the latest one. Do I use

"SELECT max(thread_date) FROM thread"?
Or is there such logic?

Thanks

[subwayman]

SELECT max(thread_date) FROM thread

Yes that would work. or if you needed more columns from the record with the latest date you could use:

SELECT * FROM table ORDER BY date DESC LIMIT 1

This returns one record (LIMIT 1) with the latest date (ORDER BY date DESC)