/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 vote122 views2 answers
Select only columns that are not empty oracle sql
SQL
3 votes140 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote108 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote104 views1 answer
Max mysql
SQL
0 vote142 views1 answer
Show mysql account privilleges
SQL
0 vote107 views1 answer
Postgres drop type
SQL
0 vote106 views1 answer
Get first 3 letter of department name in sql
SQL
1 vote107 views1 answer
Mariadb alter user host
SQL
0 vote99 views1 answer
How to Remove milliseconds from Date time
SQL
32 votes120 views6 answers
Rename column mysql
SQL

Share