Answers for "postgres get week number"

SQL
1

day of week postgresql

select extract(dow from date '2016-12-18'); /* sunday */
Posted by: Guest on October-14-2021
0

postgres week number

select to_char(current_date, 'IYYY-IW');
Posted by: Guest on September-23-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language