Adam Black

This would be a nice feature to add.

This should have been part of issue #319

Thanks for the hint. I think I have a solution. Add an `extended_types` argument to and some `if` statements to [`dbDataType()`](https://github.com/r-dbi/RSQLite/blob/1423bfe86a11b173f518b846337449ae76c493ff/R/SQLiteDriver.R#L24). ``` r #' @rdname SQLiteConnection-class #' @export setMethod("dbDataType", "SQLiteConnection",...

Great! I'll work on a pulll request. Is there a development branch I should work off of or create a new branch from main?

I opened a PR with the changes and a simple test. I was hoping that adding the DBItest date/time checks would be as simple as ``` DBItest::make_context( SQLite(), list(dbname =...

I think I've made some progress and learned a little more about the DBItest package. I think that we want to use the appropriate cast functions in tweaks. `date_cast =...

Here is what I found on SQLite date functions. No datediff, datepart, or dateadd unfortunately. https://www.sqlite.org/lang_datefunc.html

Here are some examples for manipulating dates in SQLite using RSQLite. One tricky part is the time zone. When data is loaded into SQLite from R using `dbWriteTable` I think...

Here is an example using `dbWriteTable` that does not work as expected. I tried a few variations using lubridate package to create the date but still no luck. ``` r...

Interesting @MVesuviusC. I have a few questions. Is it possible to get the timezone for a datetime column in RSQLite? It looks to me like[ SQLite does not actually support...