[R-sig-DB] timestamp support (Was: RSQLite and SQLite 3.3.x)

[Dirk Eddelbuettel]

On 29 September 2006 at 12:44, Jeffrey Horner wrote:
| But I do get the following message when calling dbGetQuery() when a 
| table contains the timestamp type:
| 
| 1: RS-DBI driver warning: (unrecognized MySQL field type 7 in column 2 
| imported as character)
| 2: RS-DBI driver warning: (unrecognized MySQL field type 7 in column 2 
| imported as character)

Turns out that I use timestamp quite heavily right now, and to the best of
limited knowledge timestamps are

-- not supported by DBI and RMySQL/ RSQlite
-- not supported by Rdbi and RdbiPgSQL

but are 

-- supported natively by RODBC

so I am back to using RODBC even though I dislike having to twiddle with
odbc.ini and friends.

Dirk 

-- 
Hell, there are no rules here - we're trying to accomplish something. 
                                                  -- Thomas A. Edison