Conversion of mon type time format in Oracle and resolution of invalid month and year error

Time:2020-11-23

Time conversion NLS in different systems_ DATE_ Usage of language:

English: NLS_ DATE_ LANGUAGE=AMERICAN

Japanese: NLS_ DATE_ LANGUAGE = Japanese

Chinese: NLS_ DATE_ LANGUAGE = SIMPLIFIED CHINESE

 

Summarize the solution:

  select TO_CHAR(to_date(’23-JUN-99′,’dd-MON-YY’,’NLS_DATE_LANGUAGE=AMERICAN’),’YYYY-MM-DD’) from dual;

Recommended Today

A detailed explanation of the differences between Perl and strawberry Perl and ActivePerl

Perl is the abbreviation of practical extraction and report language “practical report extraction language”. Application of activestateperl and strawberry PERL on Windows platformcompiler。 Perl   The relationship between the latter two is that C language and Linux system have their own GCC. The biggest difference between activestate Perl and strawberry Perl is that strawberry Perl […]