Using Date and Time Data Types with Aggregate Functions

Go Up to Working with Dates and Times

You can use the date and time data types with the MIN(), MAX(), COUNT() functions, the DISTINCT argument to those functions, and the GROUP BY argument to the SELECT() function. An attempt to use SUM() or AVG() with date or time data types returns an error.

Advance To:

• Embedded SQL Guide