skip to main content
Supported SQL statements and extensions : SQL expressions : Literals : Date/Time literals
  

Try DataDirect Drivers Now
Date/Time literals
Date and time literal values are enclosed in single quotion marks ('value').
*The format for a Date literal is DATE'date'.
*The format for a Time literal is TIME'time'.
*The format for a Timestamp literal is TIMESTAMP'ts'.