skip to main content
Supported SQL functionality : SQL expressions : Literals : Date and time literals
  

Try DataDirect Drivers Now
Date and 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'.