select extract(month from (current_date))
from rdb$database
Prvi dan u mesecu, poslednji dan u mesecu:
Code:
select
(current_date - EXTRACT(DAY FROM current_date) + 1) as firstdate,
(current_date - EXTRACT(DAY FROM current_date) + 32 -
EXTRACT(DAY FROM current_date -
EXTRACT(DAY FROM current_date) + 32)) as lastday
from rdb$database
Someone's sitting in the shade today because someone planted a tree a long time ago.