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

Go carbon version 1.2.0 has been released to improve and optimize the multi scenario support for orm

Carbon is a lightweight, semantic and developer friendly golang time processing library, which supports chain call, lunar calendar, Gorm, xorm and other mainstream orm If you think it’s good, please give it to a star github:github.com/golang-module/carbon gitee:gitee.com/go-package/carbon Installation and use //Using GitHub Library go get -u github.com/golang-module/carbon import ( “github.com/golang-module/carbon”) //Using gitee Library go get […]