Displaying 1 result from an estimated 1 matches for "tr_tickdata".
2009 Nov 30
1
RSQLite does not read very large values correctly
...29467907000
Now I run this R Code:
> library("DBI")
> library("RSQLite")
>
> # DB Connection
> con <- dbConnect(dbDriver("SQLite"), "C:/Temp/TickDB01.db")
> raw_Data <- dbGetQuery(con, "SELECT OrderID, Day, TimeToClose FROM
Tr_TickData WHERE OrderID in (1,2,3)")
> raw_Data
OrderID Day TimeToClose
1 1 2009-11-25 -596864072
2 2 2009-11-25 -596864072
3 3 2009-11-25 -596864072
The values are totally wrong... Is it because RSQLite has a problem with
big numbers?
TimeToClose is microseconds til...