/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 vote187 views2 answers
On update cascade
SQL
2 votes195 views1 answer
Sql update alias
SQL
0 vote200 views4 answers
Stored procedure sql
SQL
0 vote195 views1 answer
Cross apply top for each row t1
SQL
0 vote203 views1 answer
Kill a pid redshift
SQL
0 vote193 views1 answer
Less mysql display
SQL
0 vote174 views1 answer
Suse start MySQL
SQL
0 vote196 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote195 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote212 views1 answer
Get only one row in mysql
SQL

Share