[R] SQL Dates

Paul Sorenson Paul.Sorenson at vision-bio.com
Wed Aug 13 01:36:54 CEST 2003


How can I have SQL queries (ODBB/Windows) return dates (cf text) for date columns?

I can successfully query and ODBC database with R.  I can subsequently convert the text representations of dates in columns using as.POSIXxx functions but I figured there must be a way to achieve this at the time of the query.

Any tips?

paul




More information about the R-help mailing list