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 '#--------------------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";