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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.