Displaying 1 result from an estimated 1 matches for "pat_data".
Did you mean:
plat_data
2012 Oct 04
0
RPostgreSQL Date format problem
...ng required package: DBI
> dbhost <- Sys.getenv("PGHOST")
> m <- dbDriver("PostgreSQL")
> con <- dbConnect(m, dbname = "db", host = dbhost)
> query <- "SELECT pat_dob_dt from patients where pat_dob_dt like '%1980';">
> pat_data <- dbGetQuery(con, statement = query)
> pat_data
pat_dob_dt
1 4-05-19
2 1-12-19
3 4-05-19
4 2-10-19
5 5-01-19
6 25-09-19
7 14-12-19
8 22-07-19
9 24-01-19
10 1-07-19
As you can see it strips off the last two digits in the year, and converts
the "/&qu...