Postgres: Query Results from Today Only
When you want to query only on results from today in a Postgres database use the >= now()::date syntax.
Example
select *
from orders
where create_time >= now()::date
When you want to query only on results from today in a Postgres database use the >= now()::date syntax.
select *
from orders
where create_time >= now()::date
