postgresql - how I can extract data between now and the end of the current date? Postgres -

i need extract last hundred calls until end of current date

ejm:

select * call create_at between >= yyyy-mm-dd 00:00:00 , <= yyyy-mm-dd 23:59:59 limit 100

how can extract data between range?

current date, meaning today?

select * call   create_at between 'today' , 'tomorrow'   limit 100 

as mentioned, want sort them, logically sorting them backwards give last 100

select * call   create_at between 'today' , 'tomorrow'   order create_at desc   limit 100 

you mentioned "from now", if don't want gone times, can use (with order or not)

select * call   create_at between now() , 'tomorrow'   limit 100