1
'#--------------------FN_DYNVARS_060_01-------------------------#'
2
SET @@global.lc_time_names = "en_CA";
3
'connect (con1,localhost,root,,,,)'
5
SELECT @@global.lc_time_names;
8
SELECT @@session.lc_time_names;
9
@@session.lc_time_names
11
SET @@global.lc_time_names = "en_IN";
12
'connect (con2,localhost,root,,,,)'
14
SELECT @@global.lc_time_names;
15
@@global.lc_time_names
17
SELECT @@session.lc_time_names;
18
@@session.lc_time_names
20
'#--------------------FN_DYNVARS_060_02-------------------------#'
23
SET @@session.lc_time_names = 'en_US';
24
SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12');
25
DATE_FORMAT('2010-01-01','%W %a %M %b') DAYNAME('2010-05-05') MONTHNAME('2010-12-12')
26
Friday Fri January Jan Wednesday December
27
SET @@session.lc_time_names = 'ar_AE';
28
SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12');
29
DATE_FORMAT('2010-01-01','%W %a %M %b') DAYNAME('2010-05-05') MONTHNAME('2010-12-12')
30
الجمعة ج يناير ينا الأربعاء ديسمبر
31
SET @@session.lc_time_names = 'es_ES';
32
SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12');
33
DATE_FORMAT('2010-01-01','%W %a %M %b') DAYNAME('2010-05-05') MONTHNAME('2010-12-12')
34
viernes vie enero ene miércoles diciembre
35
SET @@session.lc_time_names = 'fi_FI';
36
SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12');
37
DATE_FORMAT('2010-01-01','%W %a %M %b') DAYNAME('2010-05-05') MONTHNAME('2010-12-12')
38
perjantai pe tammikuu tammi keskiviikko joulukuu
39
SET @@session.lc_time_names = 'gu_IN';
40
SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12');
41
DATE_FORMAT('2010-01-01','%W %a %M %b') DAYNAME('2010-05-05') MONTHNAME('2010-12-12')
42
શુક્રવાર શુક્ર જાન્યુઆરી જાન બુધવાર ડિસેમ્બર
43
SET @@session.lc_time_names = 'it_IT';
44
SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12');
45
DATE_FORMAT('2010-01-01','%W %a %M %b') DAYNAME('2010-05-05') MONTHNAME('2010-12-12')
46
venerdì ven gennaio gen mercoledì dicembre
47
SET @@session.lc_time_names = 'pt_BR';
48
SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12');
49
DATE_FORMAT('2010-01-01','%W %a %M %b') DAYNAME('2010-05-05') MONTHNAME('2010-12-12')
50
sexta Sex janeiro Jan quarta dezembro
51
SET @@session.lc_time_names = 'ur_PK';
52
SELECT DATE_FORMAT('2010-01-01','%W %a %M %b'), DAYNAME('2010-05-05'),MONTHNAME('2010-12-12');
53
DATE_FORMAT('2010-01-01','%W %a %M %b') DAYNAME('2010-05-05') MONTHNAME('2010-12-12')
54
جمعه جمعه جنوري جنوري بدھ دسمبر
55
SET @@global.lc_time_names = "en_US";