Literal DATETIME

The following examples show literal DATETIME as an expression:

SELECT DATETIME (1997-12-6) YEAR TO DAY FROM customer

UPDATE cust_calls SET res_dtime = DATETIME (1998-07-07 10:40)
         YEAR TO MINUTE
   WHERE customer_num = 110
   AND call_dtime = DATETIME (1998-07-07 10:24) YEAR TO MINUTE

SELECT * FROM cust_calls 
   WHERE call_dtime
   = DATETIME (1998-12-25 00:00:00) YEAR TO SECOND

For more information, see Literal DATETIME.