slu_date_to_sqlite {sqliteutils}

Converts dates to the numeric values as which they would be stored on SQLite

Description

Converts dates to the numeric values as which they would be stored on SQLite

Usage

slu_date_to_sqlite(date_r)

Arguments

date_r

dates as returned by as.Date() in R

Value

integers that correspond to the numbers that are stored on SQLite when DBI:dbWriteTable is used

Examples

con <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
data <- data.frame(
    date = as.Date("2021-09-19")
)
DBI::dbWriteTable(conn = con, name = "dates", value = data )
data_from_bd <- dplyr::tbl(src = con, "dates") %>%  dplyr::collect()
data_with_sqlite_dates <- data %>%
dplyr::mutate(
    date = slu_date_to_sqlite(date)
)
print(data_from_bd)
print(data_with_sqlite_dates)
DBI::dbDisconnect(con)