Options

how to use to_date in read database for oracle query

sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II
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

Answers

  • Options
    BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn
    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
Sign In or Register to comment.