to_date conversion not working from character hardcoding in the query, getting error 'ORA-01843: not a valid month'

Asked Oct 20 '17 at 07:30

Active Dec 09 '17 at 18:06

Viewed 47 times

select to_date('01-MAR-17','DD-MON-YY') from dual

edited Dec 09 '17 at 18:06

Cœur

asked Oct 20 '17 at 07:30

Manoj

5

Possibly specify the `nls_language`? If your database (or the connection; unsure) settings aren't set to English, it may not be parsing English month names. – Jon Skeet Oct 20 '17 at 07:34
4

Better even avoid month names at all. (And two-digit years for that matter.) Use date literals: `select date '2017-03-01' from dual;`. – Thorsten Kettner Oct 20 '17 at 07:51
More specifically, [`nls_date_language`](https://stackoverflow.com/q/28211982/266304) - at least if you’re stuck with that string format. If you have a choice though, use date literals or at least month numbers and an unambiguous date format. – Alex Poole Oct 20 '17 at 07:55

0 Answers0