diff options
Diffstat (limited to 'mysql-test/r/locale.result')
| -rw-r--r-- | mysql-test/r/locale.result | 49 |
1 files changed, 49 insertions, 0 deletions
diff --git a/mysql-test/r/locale.result b/mysql-test/r/locale.result new file mode 100644 index 00000000000..467eb97b639 --- /dev/null +++ b/mysql-test/r/locale.result @@ -0,0 +1,49 @@ +DROP TABLE IF EXISTS t1; +Start of 5.4 tests +# +# WL#4642 Greek locale for DAYNAME, MONTHNAME, DATE_FORMAT +# +SET NAMES utf8; +SET @@lc_time_names=109; +SELECT @@lc_time_names; +@@lc_time_names +el_GR +CREATE TABLE t1 (a DATE); +INSERT INTO t1 VALUES +('2006-01-01'),('2006-01-02'),('2006-01-03'), +('2006-01-04'),('2006-01-05'),('2006-01-06'),('2006-01-07'); +SELECT a, date_format(a,'%a') as abday, dayname(a) as day FROM t1 ORDER BY a; +a abday day +2006-01-01 Κυρ Κυριακή +2006-01-02 Δευ Δευτέρα +2006-01-03 Τρί Τρίτη +2006-01-04 Τετ Τετάρτη +2006-01-05 Πέμ Πέμπτη +2006-01-06 Παρ Παρασκευή +2006-01-07 Σάβ Σάββατο +DROP TABLE t1; +CREATE TABLE t1 (a DATE); +INSERT INTO t1 VALUES +('2006-01-01'),('2006-02-01'),('2006-03-01'), +('2006-04-01'),('2006-05-01'),('2006-06-01'), +('2006-07-01'),('2006-08-01'),('2006-09-01'), +('2006-10-01'),('2006-11-01'),('2006-12-01'); +SELECT a, date_format(a,'%b') as abmon, monthname(a) as mon FROM t1 ORDER BY a; +a abmon mon +2006-01-01 Ιαν Ιανουάριος +2006-02-01 Φεβ Φεβρουάριος +2006-03-01 Μάρ Μάρτιος +2006-04-01 Απρ Απρίλιος +2006-05-01 Μάι Μάιος +2006-06-01 Ιούν Ιούνιος +2006-07-01 Ιούλ Ιούλιος +2006-08-01 Αύγ Αύγουστος +2006-09-01 Σεπ Σεπτέμβριος +2006-10-01 Οκτ Οκτώβριος +2006-11-01 Νοέ Νοέμβριος +2006-12-01 Δεκ Δεκέμβριος +SELECT format(123456.789, 3, 'el_GR'); +format(123456.789, 3, 'el_GR') +123456.789 +DROP TABLE t1; +End of 5.4 tests |