11.23 'YESTERDAY'
Available inDSQL, PSQL, ESQL
TypeCHAR(9)
'YESTERDAY'
is not a variable, but a string literal.
It is, however, special in the sense that when you CAST()
it to a date/time type, you will get the date of the day before.
See also Section 11.20, 'TODAY'
.
Examples
select 'Yesterday' from rdb$database
-- returns 'Yesterday'
select cast('Yesterday as date) from rdb$database
-- returns e.g. 2011-10-02
select cast('YESTERDAY' as timestamp) from rdb$database
-- returns e.g. 2011-10-02 00:00:00.0000