Oracle Compare Date Time

1.Compare Date and Time

In this command, we will compare the column c_date with the system current date follow a format

 

WHERE c_date <= trim(to_char(sysdate,’yyyymmdd’));

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.