lc_time_names

Description

The lc_time_names variable specifies the language to be used for displaying date and month names and abbreviations.

Privilege requirements

• Query variables

  • Global level

    In MySQL mode, the sys tenant and all user tenants can query the value of global system variables by executing the SHOW VARIABLES statement or querying the information_schema.GLOBAL_VARIABLES view.

  • Session level

    All sys tenants and user tenants can view the value of a session-level system variable by using the SHOW VARIABLES statement or query the information_schema.SESSION_VARIABLES view in MySQL mode.

• Modify variables

  • Global level

    • The sys tenant can directly modify the value of a Global system variable.

    • A MySQL user in a user tenant must have the SUPER or ALTER SYSTEM privilege to modify the value of a global system variable.

  • Session level

    In a user tenant, you can modify the value of a session-level system variable of the current tenant.

Attributes

Description

This variable affects the output of the DATE_FORMAT()、DAYNAME() and MONTHNAME() functions but does not affect the output of the STR_TO_DATE() or GET_FORMAT() functions.

Examples

For example:

1. Set the language for display date and month names and abbreviations to Chinese.

   • Session level

     obclient> SET lc_time_names='zh_CN';
     

   • Global level

     obclient> SET GLOBAL lc_time_names='zh_CN';
     

2. Run the following statement to query the value of the lc_time_names variable:

   obclient> show variables like "lc_time_names";
   

   The return result is as follows:

   +---------------+-------+
   | Variable_name | Value |
   +---------------+-------+
   | lc_time_names | zh_CN |
   +---------------+-------+
   1 row in set (0.015 sec)
   

3. Use the DAYNAME() function to query the name of the week corresponding to the input date.

   obclient> select DAYNAME('2023-01-06');
   

   The result set is as follows:

   +-----------------------+
   | DAYNAME('2023-01-06') |
   +-----------------------+
   | Friday                |
   +-----------------------+
   1 row in set (0.000 sec)
   

References

• DATE_FORMAT
• DAYNAME
• MONTHNAME