Date constants may be expressed in SQL statements as a character string or embedded in a vendor string. SQL_CHAR
and the vendor string representation are treated as a value of type SQL_DATE
. This becomes important when conversions are attempted.
Pervasive PSQL partially supports extended SQL grammar, as outlined in this function.
The next two statements return all the classes whose start date is after 1995-06-05.
Pervasive PSQL supports the following date literal format: 'YYYY-MM-DD'.
Dates may be in the range of year 0 to 9999.