WL#4642: Greek locale for DAYNAME, MONTHNAME, DATE_FORMAT

Affects: Server-5.5   —   Status: Complete   —   Priority: Medium

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