/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

0 vote263 views1 answer
Alter fedora mysql 8.0 user
SQL
0 vote250 views1 answer
Sql database connectivity
SQL
1 vote281 views1 answer
Show databases mysql docker
SQL
0 vote266 views1 answer
Postgresql on conflict pair
SQL
0 vote234 views1 answer
How to check replication lag in mySQL
SQL
0 vote247 views1 answer
How to convert DateTime to VarChar SQL
SQL
13 votes256 views3 answers
Sql select from multiple tables without join
SQL
1 vote256 views1 answer
Increase existing date in sql oracle
SQL
0 vote240 views1 answer
Database springboot
SQL
1 vote254 views1 answer
Oracle duration between timestamps
SQL

Share