/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 votes257 views5 answers
Unique in sql server
SQL
1 vote128 views1 answer
Date in where on datetime column clause mysql
SQL
6 votes137 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote252 views1 answer
The differnece between to values in sql
SQL
0 vote120 views1 answer
Postgresql where clause not working
SQL
0 vote139 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
0 vote129 views1 answer
Min varias colunas spark sql
SQL
0 vote135 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote128 views1 answer
Implicit inner join table alias with id values
SQL
0 vote110 views1 answer
CREATE MULTIPLE FK
SQL

Share