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.