search for: pat_dob_dt

Hi, I've just started using RPostgreSQL within R to interrogate a PostgreSQL database. The problem I have is that a column containing dates shows up differently in R than in the database: here is the output direct from the psql database in Linux: db=> select pat_dob_dt from patients where pat_dob_dt like '%1980'; pat_dob_dt ------------ 04/05/1980 01/12/1980 04/05/1980 02/10/1980 05/01/1980 25/09/1980 14/12/1980 22/07/1980 24/01/1980 01/07/1980 (10 rows) and here is output from within R: R version 2.15.1 (2012-06-22) -- "Roasted Marshma...