/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 vote293 views1 answer
Mysql select field if condition
SQL
0 vote178 views1 answer
Postgresql delete limit
SQL
0 vote174 views1 answer
If column value is null then in mysql
SQL
0 vote163 views1 answer
Sql server manager close connection
SQL
0 vote198 views1 answer
How to print sql query
SQL
0 vote221 views1 answer
Selecting Multiple Columns in SQL
SQL
1 vote128 views1 answer
Oracle character set
SQL
1 vote165 views1 answer
Sql auto date
SQL
0 vote179 views1 answer
Oracle session statistics
SQL
1 vote187 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL

Share