4.2. SQL Temporal Data Types

Standard SQL has a very complete description of its temporal data types. There are rules for converting from numeric and character strings into these data types, and there is a schema table for global time-zone information that is used to make sure temporal data types are synchronized. It is so complete and elaborate that nobody has implemented it yet—and it will take them years to do so! Because it is an international standard, Standard SQL has to handle time for the whole world, and most of us work with only local time. If you have ever tried to figure out the time in a foreign city before placing a telephone call, you have some idea of what is involved.

The common terms and conventions related to time are also ...

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

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