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, [EMAIL PROTECTED] 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 ______________________________________________ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help
