Quick question... using the standard dbplyr verbs, how can I access and use the database's sysdate value, such as for filtering, etc.?
As an example, how do I do, without doing raw sql (but with select/filter/mutate verbs) do:
select sysdate from dual
Trying this:
dual_tbl <-
tbl(con, "dual")
dual_tbl %>%
select(sysdate)
#> Error: Can't subset columns that don't exist.
#> x Column `sysdate` doesn't exist.