oracle sql date not later than today?

Question

I need to display some data if it's a - new data - updated data let's say, I will be basing these data from a publishdate column and updated column where publishdate and updateddate are both timestamps ? . so how to compute the date if it's a new one ?

Answer 1

You need to use the CASE clausule and inside this clausule resolved the comparations, and remember, today (now) is sysdate.

Example Select a, b, c, case d <= (sysdate - 1) ....

Solution is easy, learn how to use this clausule.

Regards.