9.2. CURRENT_DATE

Available inDSQL, PSQL, ESQL

Syntax 

  |CURRENT_DATE

TypeDATE

DescriptionCURRENT_DATE returns the current server date.

Examples 

  |select current_date from rdb$database
  |-- returns e.g. 2011-10-03

Notes

  • Within a PSQL module (procedure, trigger or executable block), the value of CURRENT_DATE will remain constant every time it is read. If multiple modules call or trigger each other, the value will remain constant throughout the duration of the outermost module. If you need a progressing value in PSQL (e.g. to measure time intervals), use Section 9.17, “'TODAY'”.