Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

comparing date's

User_R4VJDJun 9 2021

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

Comments

Post Details

Added on Jun 9 2021
5 comments
129 views