/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

2 votes298 views1 answer
Where clause for child record apex
SQL
3 votes266 views1 answer
Ms sql skip take
SQL
0 vote254 views1 answer
What does the -p flag do in mysql cli
SQL
1 vote273 views1 answer
Mysql batch insert
SQL
5 votes262 views2 answers
Oracle show procedures
SQL
0 vote318 views1 answer
Pagination with row_number
SQL
1 vote310 views1 answer
Mariadb get column names from table
SQL
0 vote264 views1 answer
Sql row number in result set
SQL
0 vote270 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
0 vote243 views1 answer
Mysql does collate nopad recognize space
SQL

Share