Repository navigation
Convert excel DATE to sqlite DATE #81
Description
Activity
Using the suggestion by @Aman_Srivastava here: https://stackoverflow.com/questions/2770168/excel-sqlite-date-serial-numbers
I converted the COLUMNWITHDATE into a date with:
DATE(( COLUMNWITHDATE - 25569) * 86400 , 'unixepoch')would it be possible to apply a similar conversion? Obviously it could be used afterwards as well by other users.
Reacted by Nicolas Bétheuil
sqlitebiter is a very efficient xlsx conversion sqlite tool.
But Excel DATE type will be converted to INTEGER,
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