/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 vote317 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
1 vote260 views1 answer
Foreign key constraint in ms sql
SQL
0 vote287 views1 answer
Sql datediff db2
SQL
0 vote279 views1 answer
Events not working db
SQL
4 votes289 views3 answers
Copy table postgres
SQL
3 votes298 views3 answers
Restart mysql mac
SQL
3 votes287 views4 answers
Show databases in sql server
SQL
0 vote295 views1 answer
Delete first row in sql
SQL
15 votes295 views7 answers
MYSQL
SQL
0 vote318 views1 answer
Select the date 30 days less that the todays date sql request
SQL

Share