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.