The SET CURRENT LOCALE LC_TIME statement changes the value
of the CURRENT LOCALE LC_TIME special register. It is not under transaction
control.
Invocation
This statement can be embedded
in an application program or issued interactively. It is an executable
statement that can be dynamically prepared.
Authorization
None required.
Syntax
.-=-.
>>-SET--CURRENT--LOCALE--LC_TIME--+---+--+-host-variable---+---><
'-string-constant-'
Description
The CURRENT LOCALE LC_TIME special
register is used by the
DAYNAME, MONTHNAME,
NEXT_DAY, ROUND, ROUND_TIMESTAMP, TIMESTAMP_FORMAT, TRUNCATE, TRUNC_TIMESTAMP
and VARCHAR_FORMAT functions when the
locale-name argument
is not explicitly specified.
- host-variable
- A variable of type CHAR or VARCHAR. It cannot be set to null.
- string-constant
- A character string constant.
Notes
- Initial Value: The initial value of the CURRENT
LOCALE LC_TIME special register is 'en_US'.
- Potential future use: In a future release the value
of the CURRENT LOCALE LC_TIME special register might be used by other
scalar functions and for other areas of the database environment that
involve datetime values.
- Valid locales and naming: For
information about valid locales and their naming, see the Related
reference section at the end of this topic.