3
votes
2answers
2k views

Consequences of changing NLS_TIMESTAMP_FORMAT

I administer a 9.2.0.8 database where the NLS_TIMESTAMP_FORMAT is set to 'DD-MON-RR HH.MI.SSXFF AM';. This leads to odd results when using the CAST TO TIMESTAMP function: select CAST('14-SEP-2011' ...