How to Query Date and Time in PostgreSQL ¶
Get the date and time time right now ¶
select now(); -- date and time
select current_date; -- date
select current_time; -- time
Find rows between two absolute timestamps ¶
select count(1)
from events
where time between '2020-04-01' and '2020-04-31';