Debian Codegraph @

mysql-test/suite/sys_vars/r/lc_time_names_func.result

raw
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 disconnect con2;
21 disconnect con1;
22 '#--------------------FN_DYNVARS_060_02-------------------------#'
23 connection default;
24 SET NAMES 'utf8';
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";