Displaying 1 result from an estimated 1 matches for "dsflag".
Did you mean:
dflag
2013 Apr 12
0
RODBC MSSQL query with date - time tag
...lt;'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 obtain no results:
[1] time_tag insert_time dsflag numpts gse_bx gse_by
gse_bz gse_lat gse_lon gsm_bx gsm_by gsm_bz
gsm_lat gsm_lon bt
<0 rows> (or 0-length row.names)
If I omit the time_tag parameter, I get the following:
> sqlQuery(channel1,"select * from tb_ace_mag_1m", max=10...