SET_LOCAL() Supported Language Descriptions
SET_LOCALE()
The SET_LOCAL() function allows the setting of a specific language environment for the specified date.The method it uses is：
SET_LOCALE(date, locale_modifier)
date: indicates the specified date. locale_modifier：indicates a language environment descriptor.
This function must be used in conjunction with Datetime_FORMAT().For example：
DATETIME_FORMAT(SET_LOCALE(NOW(), "ko"), "LLLL")
"Ko" means output date to "Korean".
List of descriptors
Language description supported in AITable：
| Language environment descriptor (lowercase) | Description | Examples |
|---|---|---|
| en | English | DATETIME_FORMAT(SET_LOCALE(NOW(), "en"), "LLLL") =>Saturday, July 18, 2020 4:45 PM |
| zh-cn | Chinese Simplified | DATETIME_FORMAT(SET_LOCALE(NOW(), "zh-cn"), "LLLL") =>2020年7月18日星期六下午4点35分 |
| zh-tw | Chinese Traditional | DATETIME_FORMAT(SET_LOCALE(NOW(), "zh-tw"), "MMMD,ddd") =>7月18,週六 |
| fr | French | DATETIME_FORMAT(SET_LOCALE(NOW(), "fr"), "LLLL") =>samedi 18 juillet 2020 16:35 |
| es | Spanish | DATETIME_FORMAT(SET_LOCALE(NOW(), "es"), "LLLL") =>sábado, 18 de Julio de 2020 16:35 |
| pt | Portuguese | DATETIME_FORMAT(SET_LOCALE(NOW(), "pt"), "LLLL") =>Sábado, 18 de Julho de 2020 às 16:35 |
| ru | Russian | DATETIME_FORMAT(SET_LOCALE(NOW(), "ru"), "LLLL") =>суббота, 18 июля 2020 г., 16:35 |
| ar | Arabic | DATETIME_FORMAT(SET_LOCALE(NOW(), "ar"), "LLLL") =>السبت 18 يوليو 2020 16:35 |
| de | German | SET_LOCALE(NOW(), "de"), "LLLL") =>Samstag, 18. Juli 2020 16:35 |
| ja | Japanese | SET_LOCALE(NOW(), "ja"), "LLLL") =>2020年7月18日 土曜日 16:35 |
| ko | Korean | SET_LOCALE(NOW(), "ko"), "LLLL") =>2020년 7월 18일 토요일 오후 4:35 |
| hi | Hindi | SET_LOCALE(NOW(), "hi"), "LLLL") =>शनिवार, 18 जुलाई 2020, PM 4:35 बजे |