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

1. select 'Yesterday' from rdb$database
2. -- returns 'Yesterday'

4. select cast('Yesterday as date) from rdb$database
5. -- returns e.g. 2011-10-02

7. select cast('YESTERDAY' as timestamp) from rdb$database
8. -- returns e.g. 2011-10-02 00:00:00.0000