/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 vote137 views1 answer
UseSqlServer no definition
SQL
1 vote115 views1 answer
Update foreign key value in mysql
SQL
7 votes116 views3 answers
Restore postgres database from sql file
SQL
3 votes131 views1 answer
Sql add two values together
SQL
0 vote119 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
0 vote111 views1 answer
Count number of entires by months sql
SQL
0 vote114 views1 answer
Select only one row sql
SQL
0 vote120 views1 answer
Date datatype in livesql
SQL
2 votes114 views2 answers
How to create an empty table from an existing table
SQL
4 votes124 views5 answers
Primary key
SQL

Share