An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
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?
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