9.2. CURRENT_DATE
Available in
DSQL, PSQL, ESQL
Syntax
CURRENT_DATE
Type
DATE
Description
CURRENT_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'TODAY'
.