The CURRENT LOCALE LC_TIME special register identifies the locale that is used for SQL statements that involve the datetime related built-in functions DAYNAME, MONTHNAME, NEXT_DAY, ROUND, ROUND_TIMESTAMP, TIMESTAMP_FORMAT, TRUNCATE, TRUNC_TIMESTAMP and VARCHAR_FORMAT. These functions use the value of CURRENT LOCALE LC_TIME if the locale-name argument is not explicitly specified.
The data type is VARCHAR(128).
The initial value of CURRENT LOCALE LC_TIME is "en_US" for English (United States). The value can be changed by invoking the SET CURRENT LOCALE LC_TIME statement.