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
SQL Dates
2 messages · paul sorenson, Brian Ripley
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