Skip to Main Content

SQL & PL/SQL

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
48 views