Progress
SQL-92
Guide and Reference


Date-time Data Types

See the "Date-time Literals" section for details on specifying values to be stored in date-time columns. See "Date-format Strings" section for details on using format strings to specify the output format of date-time columns.

This is the syntax for a date_time_data_type:

SYNTAX
DATE | TIME | TIMESTAMP 

DATE

Stores a date value as three parts: year, month, and day. The ranges for the parts are:

TIME

Stores a time value as four parts: hours, minutes, seconds, and milliseconds. The range for the parts is:

TIMESTAMP

Combines the parts of DATE and TIME.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095