• 1 de janeiro de 2022
• 1 min de leitura

Primeiro e último dia do ano

select
    date('0001-01-01') + year(current date) years - 1 year first_day_of_the_year,
    date('0001-01-01') + year(current date) years - 1 day  last_day_of_the_year
from sysibm.sysdummy1;