/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 vote129 views1 answer
Sqlcmd no headers
SQL
0 vote152 views1 answer
Default password for mysql_secure_installation in mac
SQL
1 vote133 views1 answer
Postgresql round double precision
SQL
0 vote125 views1 answer
Psql datestyle
SQL
0 vote128 views1 answer
Postgresql where clause not working
SQL
0 vote150 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote156 views1 answer
Sql delete caracter list
SQL
0 vote141 views1 answer
Sql show founctions
SQL
2 votes142 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote139 views1 answer
Oracle sql add column auto generated value
SQL

Share