Bug #117537 Query Result: Date is displayed in the format MM/DD/YYYY instead of YYYY-MM-DD

• Submitted: 20 Feb 2025 21:13
• Modified: 21 Feb 2025 8:21
• Reporter: Martin Mikušiak
• Status: Verified
• Category: Shell VSCode Extension
• Severity: S3 (Non-critical)
• Version: 1.19.1
• OS: Windows (Windows 11)
• CPU Architecture: Any
• Tags: date format

[20 Feb 2025 21:13] Martin Mikušiak

Description:
Hello,
In the Query Result - the Date is displayed in the format MM/DD/YYYY instead of YYYY-MM-DD.
I could not find any options how to change it in the Settings.

How to repeat:
Any query that selects a standard date column.

Suggested fix:
In the Settings - Please add the option to choose the preferred date display format in the Query Result, including YYYY-MM-DD.

[21 Feb 2025 8:21] MySQL Verification Team

Hello Martin Mikušiak,

Thank you for the report and feedback.

regards,
Umesh

[11 Feb 15:08] Dan Kelly

Any feedback on this issue? 

We are just in the process of upgrading to 8.4 and testing Shell Extension as a replacement for Workbench.

Having dates formatted in US date format rather than locale (en-GB) or ISO format (yyyy-mm-dd) is currently a deal breaker.