how to use to_date in read database for oracle query

sgnarkhede2016

Hello I want to check condition like  this
previously i checked this way
 trunc(Date) = trunc(SYSDATE)-1

but now my date fromat is change it comes like this 20211201,how can i change in the query using to_date function

BalazsBaranyRM

Hi,

you aren't providing the necessary details, and my experience with databases is fortunately not with Oracle.

If your Date column has the right type, the database should correctly compare it to the output of trunc(SYSDATE) (which should be unnecessary if the SYSDATE is already a date, not a timestamp). If the Date column is not a date or timestamp, but a VARCHAR, you need to cast it to a date using the appropriate Oracle function for this.

Which error message are you getting? Or where do you get the wrong data?

Regards,
Balázs