Unused NLS Time and Timestamp Parameters?

From: Frank Hubeny <fhubeny_at_ntsource.com>
Date: 2000/03/05
Message-ID: <38C33BBE.6EB2494F@ntsource.com>#1/1

If you select * from nls_database_parameters in Oracle 8i, you will see some parameter values such as nls_time_format, nls_timestamp_format, nls_time_tz_format, nls_timestamp_tz_format.

These parameters have values which do not appear to be valid formats for the to_char function: ('HH:MI.SSXFF AM', 'DD-MON-YY HH.MI.SSXFF AM', 'HH.MI.SSXFF AM TZH:TZM', 'DD-MON-YY HH.MI.SSXFF AM TZH:T') Can someone explain how these parameters are used?

Frank Hubeny Received on Sun Mar 05 2000 - 00:00:00 CST