/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 vote221 views1 answer
Sql get table last modified time
SQL
0 vote225 views1 answer
Contraint default SQL
SQL
-2 votes240 views1 answer
Trunc in sql
SQL
1 vote247 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
1 vote259 views1 answer
Liquibase alter column type / length
SQL
18 votes233 views3 answers
Mysql number format
SQL
0 vote226 views1 answer
Unique index in mysql
SQL
7 votes258 views2 answers
Sql remove duplicates based on column
SQL
16 votes247 views3 answers
Update table from another table
SQL
0 vote228 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL

Share