If the database is set to Simple Chinese zhs16gbk, lang under Windows environment variable is set to the same, want to input 12 - Dec - 2016 format of the timestamp should I do

CodePudding user response:

Didn't understand what meaning, Simple Chinese zhs16gbk also supports 12 - Dec - 2016 this data

CodePudding user response:

nls_date_format

CodePudding user response:

Write clear example to you, wait me back to look at it

CodePudding user response:

refer to the second floor sxq129601 response:

nls_date_format

The type of the field type should be a TIMESTAMP lz, try to use the following statement:

ALTER SESSION SET NLS_TIMESTAMP_FORMAT='DD - MON - RR';