/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 vote153 views1 answer
Sql character index
SQL
3 votes167 views2 answers
How to open postgresql in windows
SQL
2 votes144 views1 answer
Oracle find unusable indexes
SQL
0 vote156 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote152 views1 answer
Describe in sqlite3
SQL
6 votes154 views1 answer
Postgresql add enum value
SQL
1 vote150 views1 answer
Mysql select utc time in eastern time
SQL
5 votes181 views1 answer
Migrate sql table another database
SQL
9 votes140 views3 answers
Show table columns mysql command line
SQL
8 votes149 views1 answer
Sql remove leading spaces
SQL

Share