O'Reilly logo

Joe Celko's SQL for Smarties, 5th Edition by Joe Celko

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required