Skip to content

Convert excel DATE to sqlite DATE #81

Description

@llf007

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

Activity

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

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions