Date/time literals
- Last Updated: July 30, 2025
- 1 minute read
- DataDirect Connectors
- ODBC
- Salesforce 8.0
- Documentation
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'.