shimizu@toshiba

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?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Outcomes