开发者

ORA-01861: literal does not match format string

开发者 https://www.devze.com 2022-12-14 03:50 出处:网络
I\'m pretty sure this is something really silly. Instead of spending another 10 minutes with this ( or better said, while I spend another 10 minutes with this )I\'ll ask it here in parallel.

I'm pretty sure this is something really silly.

Instead of spending another 10 minutes with this ( or better said, while I spend another 10 minutes with this ) I'll ask it here in parallel.

What's wrong with the following statement:

select to_date( '30/10/2009 18:27:35', 'DD/MM/YYY HH24:MI:SS'开发者_Go百科) from dual

The error message is:

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

SQLState:  22008
ErrorCode: 1861
Position: 0


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

Try this with four Y's

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

0

精彩评论

暂无评论...
验证码 换一张
取 消