Примеры FIRST_DAY
FIRST_DAY
SELECT FIRST_DAY(OF MONTH FROM current_date) FROM rdb$database;
SELECT FIRST_DAY(OF YEAR FROM current_timestamp) FROM rdb$database;
SELECT FIRST_DAY(OF WEEK FROM date '2017-11-01') FROM rdb$database;
FIRST_DAY
FIRST_DAY
SELECT FIRST_DAY(OF MONTH FROM current_date) FROM rdb$database;
SELECT FIRST_DAY(OF YEAR FROM current_timestamp) FROM rdb$database;
SELECT FIRST_DAY(OF WEEK FROM date '2017-11-01') FROM rdb$database;
LAST_DAY()
DSQL, PSQL
LAST_DAY(OF <period> FROM date_or_timestamp) <period> ::= YEAR | QUARTER | MONTH | WEEK
Параметр | Описание |
---|---|
date_or_timestamp |
Выражение типа |
DATE
или TIMESTAMP [WITH | WITHOUT] TIME ZONE
Возвращает последний день года, месяца или недели для заданной даты.
Note
|
|