About the NLS_TIMESTAMP_FORMAT and NLS_TIMESTAMP_TZ_FORMAT Parameters

Specify: Default date format for:

Acceptable Values: Any any valid datetime format model. For example:

NLS_TIMESTAMP_FORMAT='YYYY-MM-DD HH:MI:SS.FF'
NLS_TIMESTAMP_TZ_FORMAT='YYYY-MM-DD HH:MI:SS.FF TZH:TZM'

For information about datetime format models, see Oracle Database SQL Language Reference.

Default Value: Set by NLS_TERRITORY, described in "About the NLS_TERRITORY Parameter".

Related Topics

Oracle Database Globalization Support Guide for more information about the NLS_TIMESTAMP_FORMAT parameter

Oracle Database Globalization Support Guide for more information about the NLS_TIMESTAMP_TZ_FORMAT parameter

Oracle Database Globalization Support Guide for information about date/time data types and time zone support

Oracle Database SQL Language Reference for more information about the TIMESTAMP datatype

Oracle Database SQL Language Reference for more information about the TIMESTAMP WITH LOCAL TIME ZONE data type