Citadel ETM (SQL Question)

[Mike@DTSI]

Having trouble understanding how the return values are created. 

I have a logged value (Logical)  I want to see the ETM (Runtime) from set times (12:20:00 to 12:40:00)

I have this valued forced HIGH the whole time of the sample.  Interval is set to 10:00.
I get back 3 records:

12:20:00   6.94444444444444E-03
12:30:00   6.94444444444444E-03
12:40:00   6.94444444444444E-03


What do the values mean?!  I was expecting a simple 10

BTW here is the SQL string:
SELECT LocalTime, "ETM{\\Mikedesktop\Server\PumpC\BC}" FROM TRACES WHERE LocalTime >= "2005-09-27 12:20:00" and LocalTime <= "2005-09-27 12:40:00" and Interval = "10:00"

Thanks
Mike

Message Edited by Mike@DTSI on 09-27-2005 02:47 PM

[Rkdomer]

Lookout (and Citadel) uses time relative to days (i.e. 24 hours = 1, 12 hours =0.5, etc) so 10 minutes would be 6.94444444444444E-03.  If you put that number into excel and format for hours:minutes it would display 0:10.  Hope this helps.

[Mike@DTSI]

Doh!  Wasnt thinking too hard today...  a quick vb format and its there

Thanks!!