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'.