[MonetDB.R] TIMESTAMPTZ

Hannes Mühleisen Hannes.Muehleisen at cwi.nl
Fri Jun 19 09:31:39 CEST 2015


Hi Roman,

> 
> Today I've met another "new" types in MonetDB:
> dbGetQuery(conn, "select now()")
> Exception in monetdbRtype(info$types[i]) : Unknown DB type TIMESTAMPTZ
I believe this was fixed in MonetDB.R 0.9.8,

> dbGetQuery(c, "select now()")
                 current_timestamp
1 2015-06-19 07:30:15.000000+00:00

> dbGetQuery(c, "select CURRENT_TIME")
           current_time
1 07:31:02.000000+00:00
> 
> dbGetQuery(conn, "select CURRENT_TIME")
> Exception in monetdbRtype(info$types[i]) : Unknown DB type TIMETZ

Please let me know if it persists after updating R, MonetDB and MonetDB.R

Hannes

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4154 bytes
Desc: not available
URL: <http://lists.r-forge.r-project.org/pipermail/monetr-users/attachments/20150619/ca4b5135/attachment.bin>


More information about the Monetr-users mailing list