Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

DATE

Description

DATE data type consists of day, month and year. A DATE literal is represented as a character string. The character string follows the DATE keyword as shown below.

DATE 'mm/dd[/yyyy]'

mm is month, dd is day, and yyyy is year. If there is no year entered, the current year will be specified automatically.

Note

All fields must be entered in integral form.

Example

DATE '11/11/1994' is stored as '11/11/1994'.
DATE '11/11' is stored as '11/11/2009'. (if a value for year is omitted, the current year is automatically specified.)