/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

16 votes352 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote341 views1 answer
Mysql locate
SQL
0 vote327 views1 answer
Postgresql where clause not working
SQL
0 vote325 views1 answer
RowDataPacket
SQL
1 vote348 views7 answers
Filter
SQL
1 vote357 views1 answer
Base64 encode sql server
SQL
0 vote341 views1 answer
Connect laravel to mysql on mac
SQL
0 vote311 views1 answer
Oracle right characters
SQL
1 vote295 views1 answer
Unique vs distinct sql
SQL
1 vote352 views1 answer
Key validation sql
SQL

Share