Name
NLS_TIMESTAMP_FORMAT
Synopsis
Value: any valid datetime format mask
Default: derived
Dynamic: ALTER SESSION
Specifies the default timestamp format to use with the TO_CHAR and TO_TIMESTAMP_TZ functions. You must enclose this value in single quotes. Default value is determined by NLS_TERRITORY. New with Oracle9i.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.