Select Time-Literal Example

The following two statements retrieve records from the class table where the start time for the classes is 14:00:00.

SELECT * FROM Class WHERE Start_time = '14:00:00'
SELECT * FROM Class WHERE Start_time = {t '14:00:00'}

Time constants may be expressed in SQL statements as a character string or embedded in a vendor string. The character string representation is treated as a string of type SQL_CHAR and the vendor string representation as a value of type SQL_TIME.

Pervasive PSQL partially supports extended SQL grammar, as outlined in this function.

Thursday, 18 April 2019 Posted in Example SQL Statements, Characteristics