Literal DATETIME
A literal DATETIME specifies the value of an DATETIME data type, including its qualifying time-units.
The following examples show literal DATETIME values as
expressions:
SELECT DATETIME (2007-12-6) YEAR TO DAY FROM customer;
UPDATE cust_calls SET res_dtime = DATETIME (2008-07-07 10:40)
YEAR TO MINUTE
WHERE customer_num = 110
AND call_dtime = DATETIME (2008-07-07 10:24) YEAR TO MINUTE;
SELECT * FROM cust_calls
WHERE call_dtime
= DATETIME (2008-12-25 00:00:00) YEAR TO SECOND;
For more information, see Literal DATETIME.