Date and time strings
Date and time strings are character strings of a specific format, and are used to write specific date and time values.
To write specific date and time values, you must write expressions explicitly. The following
expressions are specific cases of function calls with date and time
strings.
DATE('2000-06-27')
TIME('10.32.55.123456')
TIMESTAMP('2000-06-27-10.32.55.123456')
The
character strings '2000-06-27'
, '10.32.55.123456'
, and
'2000-06-27-10.32.55.123456'
are date and time strings.- Date string
- Is a character string that represents a date in the format
yyyy-mm-dd
whereyyyy
is the year,mm
is the month, anddd
is the day. - Time string
- Is a character string that represents a time in the format
hh.mm.ss.uuuuuu
, wherehh
is the hour,mm
is the minute,ss
is the second, anduuuuuu
is the microsecond. - Timestamp string
- Is a character string that represents a timestamp in the format
yyyy-mm-dd-hh.mm.ss.uuuuuu
whereyyyy
,mm
,dd
,hh
,mm
,ss
, anduuuuuu
are as above.
CREATION_DATE
specifies a date, you can use CREATION_DATE<'2000-06-25'
. The System Data Engine
converts the date string to a date value and compares the result with the date that is specified by
CREATION_DATE
.