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’));

Add Comment