/SQL/Day of week postgresql

Day of week postgresql

Datepart postgres

SELECT date_part('day', TIMESTAMP '2001-02-16 20:38:40');
Result: 16

SELECT date_part('hour', INTERVAL '4 hours 3 minutes');
Result: 4

4

Day of week postgresql

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

1

Source: stackoverflow.com

Postgres week number

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

0

Source: stackoverflow.com

Similar codes

0 vote197 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote232 views1 answer
Stratified sampling sql
SQL
0 vote202 views1 answer
Oracle call a function in a insert statement
SQL
3 votes196 views3 answers
How to add month in update sql
SQL
3 votes223 views1 answer
Get current month last date in sql server
SQL
2 votes221 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote204 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote194 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote202 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
4 votes211 views1 answer
Create db table
SQL

Share