English (Denmark) locale uses wrong date/time format

[haarp]

The en_DK locale has always been a clever workaround for the lack of a proper locale that features:

• English
• Sane date format - ISO8601 (yyyy-mm-dd)
• 24h time
• week starting on Monday

Proof:

$ LC_TIME=en_US.UTF-8 date
Sat Nov 14 04:31:38 PM CET 2020
$ LC_TIME=en_DK.UTF-8 date
2020-11-14T16:31:41 CET

(Fun fact: This locale has nothing to do with Denmark, see https://unix.stackexchange.com/a/272665)

Selecting the English (Denmark) locale in Nextcloud 19.04.4 however gives you inferior mm/dd/yyyy and 12h time. This is undoubedly a bug.

#15381 is related. #15457 and #14785 are NOT related, as this issue isn't about language, but date/time formats.

Thanks!

Server configuration

Operating system:
Debian Linux 10

Web server:
Apache 2.4.38-3+deb10u4

Database:
MariaDB 10.3.25-0+deb10u1

PHP version:
7.3.19-1~deb10u1

Nextcloud version: (see Nextcloud admin page)
19.0.4

Updated from an older Nextcloud/ownCloud or fresh install:
updated

Where did you install Nextcloud from:
integrated auto-installer/updater

Signing status:
No errors have been found.

Nextcloud configuration:

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "nope"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "overwrite.cli.url": "https:\/\/nextcloud.erppc.net\/",
        "overwritewebroot": "\/",
        "htaccess.RewriteBase": "\/",
        "dbtype": "mysql",
        "version": "19.0.4.2",
        "knowledgebaseenabled": false,
        "apps_paths": [
            {
                "path": "\/var\/www\/nextcloud\/apps",
                "url": "\/apps",
                "writable": true
            }
        ],
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "loglevel": 2,
        "mail_smtpmode": "sendmail",
        "theme": "",
        "maintenance": false,
        "trashbin_retention_obligation": "auto",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "session_lifetime": 86400,
        "mysql.utf8mb4": true,
        "updater.release.channel": "stable",
        "preview_max_x": "2048",
        "preview_max_y": "2048",
        "preview_max_filesize_image": 100,
        "app_install_overwrite": [
            "checksum"
        ]
    }
}

Client configuration

Browser:
Firefox 82.0.2

Operating system:
Linux

[szaimen]

Is this Issue still valid in NC21.0.2? If not, please close this issue. Thanks! :)

[haarp]

Is this Issue still valid in NC21.0.2? If not, please close this issue. Thanks! :)

Yes. In 21.0.2:

06/17/2021 8:13:06 PM

Week starts on Monday

[rigrig]

Still an issue in 25.0.0:

[asavah]

Many english locales are wrong.
English (europe) uses mm/dd/yyyy format, which is NOT used anywhere in Europe.
The developers should be aware that at least some English speaking people are not from America,
and that fixing bugs which were open for years might be a good thing.

[szaimen]

Hi, please update to 24.0.9 or better 25.0.3 and report back if it fixes the issue. Thank you!

My goal is to add a label like e.g. 25-feedback to this ticket of an up-to-date major Nextcloud version where the bug could be reproduced. However this is not going to work without your help. So thanks for all your effort!

If you don't manage to reproduce the issue in time and the issue gets closed but you can reproduce the issue afterwards, feel free to create a new bug report with up-to-date information by following this link: https://github.com/nextcloud/server/issues/new?assignees=&labels=bug%2C0.+Needs+triage&template=BUG_REPORT.yml&title=%5BBug%5D%3A+

[rigrig]

Still an issue:

[artonge]

Seems like it is due to moment.js not having a comprehensive list of locales. The solution would be to move to another date library that rely on the Intl API.

[szaimen]

The solution would be to move to another date library that rely on the Intl API.

sounds good to me

[adripo]

I confirm that the issue is still present in latest 24.0.10 version.
Also English(Ireland) has wrong configuration. Week starts on Sunday instead of Monday.

[adripo]

@szaimen FYI moment.js development is being stopped.

As they are suggesting, maybe we don't need moment.js anymore

[lyallp]

Nextcloud 25.0.3 and Calendar 4.4.2 still exhibit this behaviour, as in shows Sunday as the left column in the calendar, when first day of week is Monday (English - Australia)

[bendev25689]

Nextcloud 26.0.2. Denmark locale is still wrong.
Australian locale is also still wrong. We start the week on monday. Source: https://www.timeanddate.com/calendar/days/first-day-of-the-week.html
An interface such as the one in synology calendar would be ideal:

[jm355]

This still seems to be an issue, nextcloud 28.0.2.5