Displaying 1 result from an estimated 1 matches for "time_tag".
Did you mean:
time_t
2013 Apr 12
0
RODBC MSSQL query with date - time tag
Greetings:
I am trying to query an MSSQL database which contains time series data
using RODBC.
Using Server Management Studio, I can retrieve the data with this query:
Select * from tb_ace_mag_1m where time_tag>='2012-01-08 00:00:00' AND
time_tag<'2012-01-08 03:00:00'
However, when I try to accomplish this using R:
sqlQuery(channel1,"Select * from tb_ace_mag_1m where
time_tag>='2012-01-08 00:00:00' AND time_tag<'2012-01-08 03:00:00'", max=10)
I o...