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