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

Convert excel DATE to sqlite DATE #81

Open
llf007 opened this issue Dec 26, 2020 · 0 comments
Open

Convert excel DATE to sqlite DATE #81

llf007 opened this issue Dec 26, 2020 · 0 comments

Comments

@llf007
Copy link

llf007 commented Dec 26, 2020

sqlitebiter is a very efficient xlsx conversion sqlite tool.
But Excel DATE type will be converted to INTEGER,
jt_2020-12-26_15-28-57
Before each conversion to SQLite, the Excel date should be converted into text first, and then converted with sqlitebiter.

Is there any option to automatically convert the DATE to a normal value?
For example: 1900/1/1 + 44191 day + 1 day = 2020/12/26

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

No branches or pull requests

2 participants