/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

2 votes343 views1 answer
Oracle index size
SQL
0 vote345 views1 answer
Postgres copy command
SQL
0 vote337 views1 answer
Sql remove last x char
SQL
0 vote345 views1 answer
Import sql dump into postgresql database
SQL
2 votes341 views2 answers
Sqlite_busy: database is locked
SQL
40 votes460 views4 answers
PostgreSQL add column
SQL
0 vote347 views1 answer
Mysql pad zeros
SQL
2 votes361 views1 answer
How to check grants on a package in oracle
SQL
0 vote383 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote363 views1 answer
Excel vba import data to sql server
SQL

Share