/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

13 votes129 views6 answers
Mysql update from select
SQL
1 vote132 views2 answers
Mysql current user
SQL
4 votes174 views1 answer
How to check last gather stats on table in oracle
SQL
8 votes149 views3 answers
SQL column name
SQL
0 vote160 views1 answer
Sql_inner_join
SQL
0 vote145 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
1 vote129 views1 answer
Oracle explain plan
SQL
10 votes145 views4 answers
SELECT FROM WHERE
SQL
0 vote120 views1 answer
Alter boolean column postgresql
SQL
0 vote183 views1 answer
Delete from table where length sql
SQL

Share