CODE EXAMPLE FOR SQL

postgres week number

select to_char(current_date, 'IYYY-IW');