how to use to_date in read database for oracle query

sgnarkhede2016
sgnarkhede2016 New Altair Community Member
edited November 2024 in Community Q&A
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
Tagged:

Answers

  • BalazsBaranyRM
    BalazsBaranyRM New Altair Community Member
    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

Categories