/SQL/Datepart postgres

Datepart postgres

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

Similar codes

10 votes205 views4 answers
Else if mysql
SQL
10 votes205 views4 answers
Mysql one week ago
SQL
2 votes177 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote173 views1 answer
Show table details postgresql
SQL
28 votes170 views6 answers
Sql update
SQL
21 votes167 views1 answer
SQL cheat sheet pdf
SQL
-1 vote163 views2 answers
Get day in sql
SQL
0 vote597 views1 answer
How to connect .sql data set to powerbi
SQL
6 votes162 views2 answers
Mysql concatenate two columns into one
SQL
0 vote218 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL

Share