9.18. 'TOMORROW'

Available in

DSQL, PSQL, ESQL

Type

CHAR(8)

Description

'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 'TODAY'.

Examples

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

Shorthand syntax for the last two statements:

  1. select date 'Tomorrow' from rdb$database;
  2. select timestamp 'TOMORROW' from rdb$database;