Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

DATE field containing "0000-00-00" date is represented as "1899-11-30" #860

Closed
stz184 opened this issue Sep 5, 2024 · 0 comments
Closed

DATE field containing "0000-00-00" date is represented as "1899-11-30" #860

stz184 opened this issue Sep 5, 2024 · 0 comments
Assignees
@Fabio286
Labels
bug 🪲 Something isn't working MySQL/MariaDB🐬

Comments

@stz184
Copy link

stz184 commented Sep 5, 2024

In MySQL, a DATE field containing "0000-00-00" date is represented as "1899-11-30" when browsing the records in Antares which leads to confusion.

To Reproduce
Steps to reproduce the behavior:

  1. Open a MySQL table featuring a DATE field
  2. Insert a new record with "0000-00-00" as a date
  3. Browse the table contents
  4. See the date is displayed as "1899-11-30" instead of "0000-00-00"

Expected behavior
"0000-00-00" should be displayed as "0000-00-00"

Application:

  • App client MySQL
  • App version 0.7.28
  • Installation source: AppImage

Environment:

  • OS name: Ubuntu
  • OS version 24.04.1
  • DB name MySQL
  • DB version 9.0.1
@Fabio286 Fabio286 added bug 🪲 Something isn't working MySQL/MariaDB🐬 labels Sep 9, 2024
@Fabio286 Fabio286 moved this from 📌 To do to ✔ Done in Work in Progress Board Sep 29, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Fabio286 Fabio286

Labels
bug 🪲 Something isn't working MySQL/MariaDB🐬
Projects
Work in Progress Board
Status: ✔ Done
Milestone
No milestone
Development

No branches or pull requests
2 participants
@stz184 @Fabio286