/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 vote120 views1 answer
Min varias colunas spark sql
SQL
1 vote138 views1 answer
Oracle activate job
SQL
0 vote106 views1 answer
<script>alert
SQL
0 vote117 views2 answers
How to check if a column exists in a SQL Server table?
SQL
0 vote76 views2 answers
Postgresql could not start server mac
SQL
0 vote123 views1 answer
Psql get table data types
SQL
1 vote109 views1 answer
Check constraint to check if date greater than todays date
SQL
11 votes113 views5 answers
How to install sqlite3 python
SQL
0 vote113 views1 answer
Change data type in mysql
SQL
0 vote71 views1 answer
How to see the content of tables in pgadmin
SQL

Share