timestep in searching piavg

Discussion created by shimizu@toshiba on Mar 6, 2012
Latest reply on Mar 8, 2012 by ChewCheeLim

Hello, I have a question about searching piavg.


When I execute the mext SQL statement, I got "#ERROR" in the "timestep" column.


SELECT * FROM piarchive..piavg WHERE tag = 'sinusoid' AND time BETWEEN '2011/3/1' AND '2012/3/1' AND timestep = '1mo'


When I specifiy "24h" at timestep, I got "#ERROR" again.


But, when I specify the value less than "23h", I don't get any "#ERROR".


I can't specify the value greater than "24h" at timestep when I search piavg table, can I?