Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## Date-time data types

> Date-time data types are used to define points in time. Date-time data types represent calendar dates as well as times in This is the syntax for the date-time data types;

> Syntax
>     DATE | TIME | TIMESTAMP

> `DATE`

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

> - Year: 1 to 9999.
> - Month: 1 to 12.
> - Day: Lower limit is 1; the upper limit depends on the month and the year.
> `TIME`

> Stores a time value as four parts: hours, minutes, seconds, and milliseconds. The ranges for the parts are:

> - Hours: 0 to 23.
> - Minutes: 0 to 59.
> - Seconds: 0 to 59.
> - Milliseconds: 0 to 999.
> `TIMESTAMP`

> Combines the parts of `DATE` and `TIME`.

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