/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

14 votes159 views3 answers
Inner join sql oracle
SQL
4 votes135 views1 answer
Restart for pg_hba.conf file
SQL
0 vote144 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
11 votes146 views2 answers
Safe mode off mysql
SQL
0 vote149 views2 answers
Advantages of stored procedures sql
SQL
0 vote142 views1 answer
Mssql check if date is greater than today
SQL
0 vote157 views1 answer
Selecting Multiple Columns in SQL
SQL
0 vote139 views1 answer
Delete data from database sqlite android
SQL
3 votes137 views1 answer
Laravel database Using Named Bindings
SQL
31 votes167 views4 answers
Mysql grant execute
SQL

Share