Create_date
09-06-21
08-06-21
07-06-21
select * from table1
where create_date < TRUNC(sysdate);
Its returning, 08-06-21,07-06-21.
its should return , no rows
Reuirement : if create date = sysdate
we should not create order again for the sydate.
Order should be created for only one time per day