/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

1 vote183 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote212 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
0 vote193 views1 answer
How to query without duplicate rows in sql
SQL
3 votes206 views2 answers
Sqlite print all column names
SQL
19 votes188 views2 answers
Mysql tinyint max value
SQL
0 vote183 views1 answer
Set column width in sqlplus
SQL
0 vote207 views1 answer
Sql server phone constraint
SQL
0 vote194 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
0 vote204 views1 answer
Plsql find location of procedure
SQL
0 vote192 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL

Share