ORA-01861: literal does not match format string

Question

I'm sure this is really stupid.

Instead of spending another 10 minutes with this (or, better to say, while I spend another 10 minutes with this), I will ask him here in parallel.

What happened to the following statement:

select to_date( '30/10/2009 18:27:35', 'DD/MM/YYY HH24:MI:SS') from dual

Error message:

Error: ORA-01861: literal does not match format string

SQLState:  22008
ErrorCode: 1861
Position: 0

Answer 1

'DD/MM/YYY HH24:MI:SS'

Try it with four y

'DD/MM/YYYY HH24:MI:SS'