| 1 |
'#--------------------FN_DYNVARS_060_01-------------------------#' |
| 2 |
SET @@global.lc_time_names = "en_CA"; |
| 3 |
'connect (con1,localhost,root,,,,)' |
| 4 |
'connection con1' |
| 5 |
SELECT @@global.lc_time_names; |
| 6 |
@@global.lc_time_names |
| 7 |
en_CA |
| 8 |
SELECT @@session.lc_time_names; |
| 9 |
@@session.lc_time_names |
| 10 |
en_CA |
| 11 |
SET @@global.lc_time_names = "en_IN"; |
| 12 |
'connect (con2,localhost,root,,,,)' |
| 13 |
'connection con2' |
| 14 |
SELECT @@global.lc_time_names; |
| 15 |
@@global.lc_time_names |
| 16 |
en_IN |
| 17 |
SELECT @@session.lc_time_names; |
| 18 |
@@session.lc_time_names |
| 19 |
en_IN |
| 20 |
'#--------------------FN_DYNVARS_060_02-------------------------#' |
| 21 |
'connection default' |
| 22 |
SET NAMES 'utf8'; |
| 23 |
Warnings: |
| 24 |
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. |
| 25 |
SET @@session.lc_time_names = 'en_US'; |
| 26 |
SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12'); |
| 27 |
DATE_FORMAT('2010-01-01','%W %a %M %b') DAYNAME('2010-05-05') MONTHNAME('2010-12-12') |
| 28 |
Friday Fri January Jan Wednesday December |
| 29 |
SET @@session.lc_time_names = 'ar_AE'; |
| 30 |
SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12'); |
| 31 |
DATE_FORMAT('2010-01-01','%W %a %M %b') DAYNAME('2010-05-05') MONTHNAME('2010-12-12') |
| 32 |
الجمعة ج يناير ينا الأربعاء ديسمبر |
| 33 |
SET @@session.lc_time_names = 'es_ES'; |
| 34 |
SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12'); |
| 35 |
DATE_FORMAT('2010-01-01','%W %a %M %b') DAYNAME('2010-05-05') MONTHNAME('2010-12-12') |
| 36 |
viernes vie enero ene miércoles diciembre |
| 37 |
SET @@session.lc_time_names = 'fi_FI'; |
| 38 |
SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12'); |
| 39 |
DATE_FORMAT('2010-01-01','%W %a %M %b') DAYNAME('2010-05-05') MONTHNAME('2010-12-12') |
| 40 |
perjantai pe tammikuu tammi keskiviikko joulukuu |
| 41 |
SET @@session.lc_time_names = 'gu_IN'; |
| 42 |
SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12'); |
| 43 |
DATE_FORMAT('2010-01-01','%W %a %M %b') DAYNAME('2010-05-05') MONTHNAME('2010-12-12') |
| 44 |
શુક્રવાર શુક્ર જાન્યુઆરી જાન બુધવાર ડિસેમ્બર |
| 45 |
SET @@session.lc_time_names = 'it_IT'; |
| 46 |
SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12'); |
| 47 |
DATE_FORMAT('2010-01-01','%W %a %M %b') DAYNAME('2010-05-05') MONTHNAME('2010-12-12') |
| 48 |
venerdì ven gennaio gen mercoledì dicembre |
| 49 |
SET @@session.lc_time_names = 'pt_BR'; |
| 50 |
SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12'); |
| 51 |
DATE_FORMAT('2010-01-01','%W %a %M %b') DAYNAME('2010-05-05') MONTHNAME('2010-12-12') |
| 52 |
sexta Sex janeiro Jan quarta dezembro |
| 53 |
SET @@session.lc_time_names = 'ur_PK'; |
| 54 |
SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12'); |
| 55 |
DATE_FORMAT('2010-01-01','%W %a %M %b') DAYNAME('2010-05-05') MONTHNAME('2010-12-12') |
| 56 |
جمعه جمعه جنوري جنوري بدھ دسمبر |
| 57 |
SET @@global.lc_time_names = "en_US"; |