Tomorrow’s date in cast context

TypeCHAR(8), or depends on explicit CAST

'TOMORROW' 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 next day. See also Section 12.20, “'TODAY'”.

Examples

select 'Tomorrow' from rdb$database
-- returns 'Tomorrow'
 
select cast('Tomorrow' as date) from rdb$database
-- returns e.g. 2011-10-04
 
select cast('TOMORROW' as timestamp) from rdb$database
-- returns e.g. 2011-10-04 00:00:00.0000