Coldfusion Query to show the latest date in a database

How would you run a query using coldfusion & MySQL 5.0 that will show the date of the latest entry in a table? The column I would be zeroing in on has the name of date. To put it differently, I'm trying to show on a webpage the last time something was added to the database (date)
LVL 1
jasch2244Asked:
Who is Participating?
 
azadisaryevConnect With a Mentor Commented:
in general with DATE-type columns you can do:

SELECT MAX(date) AS date
FROM sometable

Azadi
0
All Courses

From novice to tech pro — start learning today.