Answers for "postgres date_trunc"

SQL
1

date_trunc postgres

SELECT DATE_TRUNC('hour', TIMESTAMP '2017-03-17 02:09:30');
Posted by: Guest on March-15-2021
3

postgresql today - 1 year

select now() - INTERVAL '1 YEAR';
Posted by: Guest on September-18-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language