/SQL/Date_trunc postgres

Date_trunc postgres

Postgresql today - 1 year

select now() - INTERVAL '1 YEAR';

3

Date_trunc postgres

SELECT DATE_TRUNC('hour', TIMESTAMP '2017-03-17 02:09:30');

2

Source: postgresqltutorial.com

Psql datetime grather than

SELECT *
FROM table
WHERE update_date >= '2013-05-03'::date
AND update_date < ('2013-05-03'::date + '1 day'::interval);

1

Source: stackoverflow.com

Similar codes

1 vote109 views1 answer
Mysql get max value and id
SQL
0 vote107 views1 answer
Mariadb datetime change to microseconds
SQL
5 votes152 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
1 vote126 views1 answer
How to put value in variable mysql
SQL
61 votes274 views6 answers
Mysql add column
SQL
8 votes108 views2 answers
Between operator
SQL
0 vote73 views1 answer
Sql table to store status
SQL
2 votes105 views1 answer
Sql alchemy or
SQL
1 vote112 views3 answers
Drop unique key constraint in sql server
SQL
1 vote68 views1 answer
Mysql show attributes of a table
SQL

Share