Cannot format given Object as a Date

User_BMQ12

Hi all! I have an oracle table that has a date column. I want to create a variable inside code with current date and do some table date condition with current date. Now when I initialize the current date - for some reason (it can be seen in the logs) it is equal to 1970-01-01. And it comes up with an error like "Cannot format given Object as a Date". It can be seen in the log. Could you suggest what is the problem?

Solomon Yakobson

Get rid of quotes:

where v.user_id = :user_id and deliv_date > to_date(:pdate,'yyyy-mm-dd')

SY.

User_BMQ12

@Solomon Yakobson Thank you!