Using Date and Time Data Types with Aggregate Functions (2024)

From InterBase

Go Up to Working with Dates and Times

See Also
What are pre-defined Date Ranges vs custom Date Ranges?


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:

See Also
Creating a Date Dimension TableCustom Date FormatsDate Format in the United States3 key factors for ensuring successful Scaffolding Operations
Using Date and Time Data Types with Aggregate Functions (2024)
Top Articles
'Subnautica' is the best survival game ever made - here’s why
Servicios de ARS privadas eficientes en República Dominicana – ADARS
Nier Automata: Everything You Need to Know
NieR creator insists that his decisions are based on what he thinks will sell, while also quipping that 'at first I listen to what the publisher wants from me, but later I don't'
Latest Posts
Tamaños de papel. ¿Cuales son los formatos más utilizados?
Converting PDF to JPG: different ways to get there
Article information

Author: Trent Wehner

Last Updated:

Views: 6188

Rating: 4.6 / 5 (56 voted)

Reviews: 87% of readers found this page helpful

Author information

Name: Trent Wehner

Birthday: 1993-03-14

Address: 872 Kevin Squares, New Codyville, AK 01785-0416

Phone: +18698800304764

Job: Senior Farming Developer

Hobby: Paintball, Calligraphy, Hunting, Flying disc, Lapidary, Rafting, Inline skating

Introduction: My name is Trent Wehner, I am a talented, brainy, zealous, light, funny, gleaming, attractive person who loves writing and wants to share my knowledge and understanding with you.