Skip to content

Convert excel DATE to sqlite DATE #81

@llf007

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

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions