[R] SQL Dates

Prof Brian Ripley ripley at stats.ox.ac.uk
Wed Aug 13 07:16:10 CEST 2003

On Wed, 13 Aug 2003, Paul Sorenson wrote:

> 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.

If you are using the ROBDC package, no.  Perhaps you would contribute an 
extension to RODBC that allows this?  (Did you look at the TODO file in 
the package?)

Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

More information about the R-help mailing list