Parsing date string with OracleDate.Parse for non-English date
Posted: Wed 11 Nov 2015 07:32
Hi,
I am having a problem trying to parse date string with OracleDate.Parse for formats like DD-MON-YYYY in non-English environment.
For example, with a NLS_DATE_LANGUAGE of "IRISH", Oracle expects 25-BEAL -2006 but OracleDate.Parse can only parse 25-May-2006.
How can I specify the language for OracleDate.Parse to parse multiple different date languages in the same application?
I am having a problem trying to parse date string with OracleDate.Parse for formats like DD-MON-YYYY in non-English environment.
For example, with a NLS_DATE_LANGUAGE of "IRISH", Oracle expects 25-BEAL -2006 but OracleDate.Parse can only parse 25-May-2006.
How can I specify the language for OracleDate.Parse to parse multiple different date languages in the same application?