Skip to content

Magento 2.4.8 GraphQL - Order items order_date wrong formatting #39805

@Dnd-Mafer

Description

@Dnd-Mafer

Preconditions and environment

  • Magento 2.4.8
  • General -> Local options -> Timezone -> Europe/Paris
  • General -> Local options -> Locale -> French (France)

Steps to reproduce

  1. Create an order
  2. Get order using GraphQL
query getOrders {
    customer {
        orders {
            items {
                orderDateOK: created_at
                orderDateFAIL: order_date
            }
        }
    }
}

Expected result

{
    "data": {
        "customer": {
            "orders": {
                "items": [
                    {
                        "orderDateOK": "2025-04-02 13:35:04",
                        "orderDateFAIL": "02/04/2025 13:35:00"
                    }
                ]
            }
        }
    }
}

Actual result

{
    "data": {
        "customer": {
            "orders": {
                "items": [
                    {
                        "orderDateOK": "2025-04-02 13:35:04",
                        "orderDateFAIL": "2007-10-16 13:35:00"
                    }
                ]
            }
        }
    }
}

Additional information

This is because of this commit.
To have a well formatted we should use an en_US locale because all date are stored in database using this format.

Release note

GraphQL - Fix badly formatted order_date on type CustomerOrder

Triage and priority

  • Severity: S0 - Affects critical data or functionality and leaves users without workaround.
  • Severity: S1 - Affects critical data or functionality and forces users to employ a workaround.
  • Severity: S2 - Affects non-critical data or functionality and forces users to employ a workaround.
  • Severity: S3 - Affects non-critical data or functionality and does not force users to employ a workaround.
  • Severity: S4 - Affects aesthetics, professional look and feel, “quality” or “usability”.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Area: OrderComponent: GraphQLGraphQLIssue: ConfirmedGate 3 Passed. Manual verification of the issue completed. Issue is confirmedPriority: P2A defect with this priority could have functionality issues which are not to expectations.Progress: PR CreatedIndicates that Pull Request has been created to fix issueReported on 2.4.8Indicates original Magento version for the Issue report.Reproduced on 2.4.xThe issue has been reproduced on latest 2.4-develop branch

    Type

    No type

    Projects

    Status

    Ready for Development

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions