Support chrono for SQLite

[mehcode]

No description provided.

[felipesere]

My current app that I am experimenting with uses a few TIMESTAMP columns which I have mapped to chrono::NaiveDateTime.

I could try to implement Encode<Sqlite> and Decode<Sqlite> based how Diesel does it?

https://docs.diesel.rs/src/diesel/sqlite/types/date_and_time/chrono.rs.html#56-97

[mehcode]

From reading sqlite documentation, all times should be UTC.

So it'd be correct to map to both DateTime<UTC> and NaiveDateTime ( with the former preferred ).

I'd expect DATETIME and TIMESTAMP to be equivalent.

Diesel seems to have the right idea but from a skim it seems that they don't support UNIX seconds.

[felipesere]

Taking this one 😄