Skip to contents

Backend-dependent time interval (in years)

Source: R/age_helpers.R
add_years.Rd

Provides the sql code for a time interval (in years).

Usage

add_years(reference_date, years, conn)

Arguments

reference_date

(Date(1) or character(1))
The date to add years to (or name of column containing the reference date).

years

(numeric(1) or character(1))
The length of the time interval in whole years (or name of column containing the number of years).

conn

(DBIConnection or function)
A database connection or function that opens a database connection.

Value

SQL query for the time interval.

Examples

  conn <- SCDB::get_connection(drv = RSQLite::SQLite())

  dplyr::copy_to(conn, data.frame(birth = as.Date("2001-04-03"), "test_age")) |>
    dplyr::mutate(first_birthday = !!add_years("birth", 1, conn))
#> Warning: Time computation on SQLite is not precise! For long time intervals, the result may be off by 1+ days. Consider using DuckDB as a local database with precise age computation.
#> Warning: Time computation on SQLite is not precise! For long time intervals, the result may be off by 1+ days. Consider using DuckDB as a local database with precise age computation.
#> Warning: Time computation on SQLite is not precise! For long time intervals, the result may be off by 1+ days. Consider using DuckDB as a local database with precise age computation.
#> # Source:   SQL [?? x 3]
#> # Database: sqlite 3.47.1 [:memory:]
#>   birth X.test_age. first_birthday
#>   <dbl> <chr>                <dbl>
#> 1 11415 test_age             11780

  DBI::dbDisconnect(conn)