If @@lc_time_names='el_GR', DAYNAME() and MONTHNAME() and DATE_FORMAT() functions should produce appropriate Greek results for day abbreviation, day, hours am/pm, month abbreviations, and months.
This task is a part of Sun Globalization Requirements. Functions DAYNAME, MONTHNAME, DATE_FORMAT currently do not support Greek locale (Tier 2). http://dev.mysql.com/doc/refman/5.0/en/locale-support.html This task will add el_GR locale with appropriate month/day names. Days ---- day abbreviation: (abday): Sunday = Κυρ "<U039A><U03C5><U03C1>"; Monday = Δευ "<U0394><U03B5><U03C5>"; Tuesday = Τρί "<U03A4><U03C1><U03AF>"; Wednesday = Τετ "<U03A4><U03B5><U03C4>"; Thursday = Πέμ "<U03A0><U03AD><U03BC>" Friday = Παρ "<U03A0><U03B1><U03C1>"; Saturday = Σάβ "<U03A3><U03AC><U03B2>"; day: Sunday = "Κυριακή" = "<U039A><U03C5><U03C1><U03B9><U03B1><U03BA><U03AE>" Monday = "Δευτέρα" = "<U0394><U03B5><U03C5><U03C4><U03AD><U03C1><U03B1>" Tuesday = "Τρίτη" = "<U03A4><U03C1><U03AF><U03C4><U03B7>" Wednesday = "Τετάρτη" = "<U03A4><U03B5><U03C4><U03AC><U03C1><U03C4><U03B7>" Thursday = "Πέμπτη" = "<U03A0><U03AD><U03BC><U03C0><U03C4><U03B7>" Friday = "Παρασκευή" = "<U03A0><U03B1><U03C1><U03B1><U03C3><U03BA><U03B5><U03C5><U03AE>" Saturday = "Σάββατο" = "<U03A3><U03AC><U03B2><U03B2><U03B1><U03C4><U03BF>" Hours ----- am= "πμ" = "<U03c0><U03bc>" pm= "μμ" = "<U03bc><U03bc>" Months ------ month abbreviation: (abmon): Jan = <U0399><U03B1><U03BD> Feb = <U03A6><U03B5><U03B2> Mar = <U039C><U03AC><U03C1> Apr = <U0391><U03C0><U03C1> May = <U039C><U03AC><U03B9> Jun = <U0399><U03BF><U03CD><U03BD> Jul = <U0399><U03BF><U03CD><U03BB> Aug = <U0391><U03CD><U03B3> Sep = <U03A3><U03B5><U03C0> Oct = <U039F><U03BA><U03C4> Nov = <U039D><U03BF><U03AD> Dec = <U0394><U03B5><U03BA> month: (mon): <U0399><U03B1><U03BD><U03BF><U03C5><U03AC><U03C1><U03B9><U03BF><U03C2> <U03A6><U03B5><U03B2><U03C1><U03BF><U03C5><U03AC><U03C1><U03B9><U03BF><U03C2> <U039C><U03AC><U03C1><U03C4><U03B9><U03BF><U03C2> <U0391><U03C0><U03C1><U03AF><U03BB><U03B9><U03BF><U03C2> <U039C><U03AC><U03B9><U03BF><U03C2> <U0399><U03BF><U03CD><U03BD><U03B9><U03BF><U03C2> <U0399><U03BF><U03CD><U03BB><U03B9><U03BF><U03C2> <U0391><U03CD><U03B3><U03BF><U03C5><U03C3><U03C4><U03BF><U03C2> <U03A3><U03B5><U03C0><U03C4><U03AD><U03BC><U03B2><U03C1><U03B9><U03BF><U03C2> <U039F><U03BA><U03C4><U03CE><U03B2><U03C1><U03B9><U03BF><U03C2> <U039D><U03BF><U03AD><U03BC><U03B2><U03C1><U03B9><U03BF><U03C2> <U0394><U03B5><U03BA><U03AD><U03BC><U03B2><U03C1><U03B9><U03BF><U03C2> month (using text notation): January = "Ιανουάριος" February = "Φεβρουάριος" March = "Μάρτιος" April = "Απρίλιος" May = "Μάιος" June = "Ιούνιος" July = "Ιούλιος" August = "Αύγουστος" September = "Σεπτέμβριος" October = "Οκτώβριος" November = "Νοέμβριος" December = "Δεκέμβριος" Nynorsk ------- During discussion about this WL and WL#751 it appeared that we're missing the Norwegian Nynorsk locale. It was decided that Nynorsk will be a separate worklog task, WL#4814 Norwegian Nynorsk locale for DAYNAME, MONTHNAME, DATE_FORMAT Authority --------- None. See comment on BUG#39092 regarding ΕΛΟΤ. On Linux distributions one can find a file named /usr/share/i18n/locales/el_GR but we do not follow it. For example our day abbreviations are as in Vista. References ---------- BUG#39092 Greek LOCALE support (feature request) dev-private email thread "WL#4642 Greek locale for DAYNAME, MONTHNAME, DATE_FORMAT, some questions" starting at [mysql intranet]/secure/mailarchive/mail.php?folder=4&mail=26821
