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.

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

Conversion of DateTime Incorrect #417

Open
Sephster opened this issue Jul 28, 2023 · 1 comment
Open

Conversion of DateTime Incorrect #417

Sephster opened this issue Jul 28, 2023 · 1 comment

Comments

@Sephster
Copy link

I have an old .accdb file that has datetime fields in it. The format for display in access is %d/%m/%y %H:%M.

Most of the dates are from the 1600's e.g. 01/04/30 00:00 which is 1630-04-01 00:00:00.

Using mdb-export to MySQL, the dates are being converted to 1900-01-00 00:00:00 which is not a valid datetime stamp, rendering the exports unusable.

Is there any workaround for this issue?

@Sephster
Copy link
Author

The fix in #368 resolves this for me

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant