/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

5 votes179 views1 answer
Mysql add user with all privileges
SQL
0 vote195 views1 answer
Get the Db column names from a SqlDataReader
SQL
0 vote179 views1 answer
Mysql update sum same table
SQL
2 votes191 views3 answers
Sql truncate table
SQL
0 vote213 views1 answer
Foreign key type uniqu mysql
SQL
3 votes278 views2 answers
Savepoint in sql
SQL
0 vote188 views1 answer
Select sql in descending order
SQL
0 vote189 views1 answer
Mysql database hyphen
SQL
12 votes187 views1 answer
How to change the value of a table in sql
SQL
1 vote198 views1 answer
Median mysql
SQL

Share