/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

10 votes133 views4 answers
SELECT FROM WHERE
SQL
2 votes128 views1 answer
Alter table add column and foreign key mysql
SQL
4 votes124 views1 answer
Sql delete multiple conditions
SQL
0 vote128 views1 answer
Back up stored procedures mysql
SQL
0 vote118 views1 answer
Incorrect datetime value sql table error 1292
SQL
1 vote140 views2 answers
Foreign key set 0
SQL
0 vote115 views1 answer
Sqlite to csv statement
SQL
0 vote136 views1 answer
Mysql get last 2 month data
SQL
65 votes303 views6 answers
Sql add column to table
SQL
0 vote118 views1 answer
Drop all tables in azure sql database
SQL

Share