Postgresql – Using time zones with as.Date in dbplyr?
I'm connecting to Postgres 15.1 in R 4.3.0 using DBI 1.2.2 and dbplyr 2.3.2. Here is a statement that works: > my_table %>% mutate(date = as.Date(created_at)) %>% head %>% pull(date) [1] "2023-09-10" "2023-11-29" "2023-12-03" "2024-04-12" "2023-12-07" "2024-04-27" But this doesn't:…