Skip to Main Content

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