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'). Review this section.
*The format for a Date literal is DATE'yyyy-mm-dd'.
*The format for a Time literal is TIME'hh:mm:ss'.
*The format for a Timestamp literal is TIMESTAMP'yyyy-mm-dd hh:mm:ss.SSSSSS'.