Chapter 4 in Joe Celko's SQL for Smarties deals with "Temporal Datatypes in SQL".

Christian Lemburg
Brainbench MVP for Perl
http://www.brainbench.com