Skip to content
Advertisement

SQL statement throws “dpiStmt_execute: ORA-01821: date format not recognized”

I am doing an SQL exercise, where I have to determine the amount of returned films to the film store at the given date “2005.06.05” and the number of films, which were borrowed at this date. Somehow I always get the errow message standing in the title. Does someone know how, where I made the mistake and how to solve it ? Thanks 🙂

Advertisement

Answer

Both to_char and to_timestamp receive data format as second parameter. And this is where the errors are

for example, this

is to be replaced presumably with that

And same goes to the to_timestamp function you use in a WHERE part

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement