SQL Basics: Datetime and Interval Data Types

October 11, 2002

[From Builder.com]

Datetimes and intervals are time-based data types that are useful for recording when a database entry was created or modified, for logging when an event occurred, or for determining how much time has elapsed since another datetime value was created. In this article from Builder.com, Shelley Doll explains the SQL92 standard's descriptions of these time-tracking types.

The complete article is available at http://builder.com.com/article.jhtml?id=u00320021008dol01.htm&page=1&vf=tt.

Back to Database Journal Home