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.