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 Last create date with sysdate

User_R4VJDJun 9 2021 — edited Jun 9 2021

Create date
Null

select * from table1
where create date < TRUNC(SYDATE)
Requirement : I have check create date should be less than sysdate.
if column is NULL, how to perform

Comments
Post Details
Added on Jun 9 2021
7 comments
773 views