Answers for "postgresql calculate week number with week starting sunday"

postgres week number

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

Posted by: Guest on September-23-2021

day of week postgresql

select extract(dow from date '2016-12-18'); /* sunday */

Posted by: Guest on October-14-2021

Code answers related to "postgresql calculate week number with week starting sunday"