Chapter 35

Temporal Queries

Abstract

Temporal data is the hardest type of data for people to handle conceptually. Perhaps, time is difficult because it is dynamic and all other data types are static or perhaps because time allows multiple parallel events.

Keywords

DATE

Derek Dongray

EXTRACT()

Holidays

ISO-8601 Standard

ISO week

Julian date

Ordinal date

Report period

Rudy Limeback

TIME

TIMESTAMP

TIMEZONE_HOUR

TIMEZONE_MINUTE

Zeller's algorithm

Y2K (year 2000)

Temporal data is the hardest type of data for people to handle conceptually. Perhaps time is difficult because it is dynamic and all other data types are static or perhaps because time allows multiple parallel events. This is an old puzzle that still catches people.

If a hen and a half ...

Get Joe Celko's SQL for Smarties, 5th Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.