How load date on SQLite

How load date on SQLite?

using SQLite, Dates, DataFrames
df = DataFrame(Column1 = [1,2,3], 
               Column2 = [today(),today()- Dates.Day(10),today()- Dates.Day(20)])
SQLite.load!(df, db, "Test", temp=false)

This way the date loads as binary

What sqlite storage class you prefer? (TEXT,Integer?)

  • Datatypes In SQLite Version 3
    ##### 2.2. Date and Time Datatype
    “SQLite does not have a storage class set aside for storing dates and/or times. Instead, the built-in Date And Time Functions of SQLite are capable of storing dates and times as TEXT, REAL, or INTEGER values:”

See related issue: