Date/Time Literals
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
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.