slu_date_to_sqlite: Converts dates to the numeric values as which they would be...

In sqliteutils: Utility Functions for '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)

sqliteutils documentation built on Sept. 21, 2021, 5:11 p.m.