/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 vote170 views1 answer
Tsql cmd exec script from file
SQL
1 vote165 views6 answers
In sql
SQL
1 vote181 views1 answer
Increasing font and zooming in mysql workbench
SQL
1 vote159 views1 answer
Round function in sql oracle
SQL
0 vote174 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
24 votes169 views5 answers
Sql reset auto increment
SQL
1 vote177 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote177 views1 answer
Mysql group by range
SQL
-1 vote182 views1 answer
Sql set max value in column
SQL
7 votes174 views1 answer
Buy forge mods server hosting
SQL

Share