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.