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:
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
andTIME
.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |