# How load date on SQLite

**URL:** https://discourse.julialang.org/t/how-load-date-on-sqlite/68231
**Category:** General Usage
**Tags:** package
**Created:** [September 15, 2021, 9:35pm UTC](https://discourse.julialang.org/t/how-load-date-on-sqlite/68231 "2021-09-15T21:35:14Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Rafael\_Brus](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/rafael_brus/32/23767_2.png) [@Rafael\_Brus](https://discourse.julialang.org/u/Rafael_Brus)
#### Post date: [September 15, 2021, 9:35pm UTC](https://discourse.julialang.org/t/how-load-date-on-sqlite/68231/1 "2021-09-15T21:35:14Z")

</div>

How load date on SQLite?

```julia
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

---

<div class="post-metadata">

### Author: ![ImreSamu](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/imresamu/32/20677_2.png) [@ImreSamu](https://discourse.julialang.org/u/ImreSamu)
#### Post date: [September 15, 2021, 11:35pm UTC](https://discourse.julialang.org/t/how-load-date-on-sqlite/68231/2 "2021-09-15T23:35:10Z")

</div>

> [@Rafael\_Brus](#):
>
> How load date on SQLite?

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

- [Datatypes In SQLite](https://www.sqlite.org/datatype3.html)  
_##### 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:

> <https://github.com/JuliaDatabases/SQLite.jl/issues/160>
>
> see discussion: https://discourse.julialang.org/t/datetimes-and-sqlite-jl-encodi…ng/16412/3