how to use to_date in read database for oracle query

User: "sgnarkhede2016"
sgnarkhede2016
New Altair Community Member
Updated by Jocelyn
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

Find more posts tagged with

AI Studio
Sort by:
1 - 1 of 11
    User: "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
Quick Links