Max Date Function SQL

No replies
thinker
thinker's picture
User is online Online
Joined: 06/02/2008
Printer-friendly versionPrinter-friendly versionSend to friendSend to friendPDF versionPDF version

Following is SQL statement to find out MAX DATE out of many records of different days. This will show the most recent record. It works for both Date and DateTime field.

SELECT    MAX(<<Column/Field Name>>) AS DATE
FROM         <<Table Name'>>

Are we being helpful? If so, please link to us here.