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