/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 vote338 views2 answers
Greater than sql server
SQL
-1 vote302 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
0 vote329 views2 answers
How to set global time_zone in mysql
SQL
8 votes279 views8 answers
Second highest salary in mysql
SQL
1 vote346 views1 answer
Key validation sql
SQL
0 vote373 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
3 votes344 views1 answer
APEX elapsed time
SQL
3 votes337 views1 answer
Uppercase and lowercase in sql
SQL
0 vote330 views1 answer
Cannot start database server xampp mac os
SQL
8 votes302 views1 answer
Oracle find text in functions
SQL

Share