skip to main content
Reference : Supported SQL Statements and Extensions : SQL Expressions : Literals : Date/Time Literals
  

Try DataDirect Drivers Now
Date/Time Literals
Date and time literal values are:
*A Date literal is enclosed in single quotation marks (' '). The format is yyyy-mm-dd.
*A Time literal is enclosed in single quotation marks (' '). The format is hh:mm:ss.
*A Timestamp is enclosed in single quotation marks (' '). The format is yyyy-mm-dd hh:mm:ss.SSSSSS.