Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Xmii and Dates


I have an issue where I believ there is a disconnect between my dates and the xmii server.

I am running the followign query against a UDS source


time as OutputDate, value as OutputValue




tag = '50210-LI-QVY-2101.01D-00' and

time >= '02-Sep-2007 06:30:00' and time <= '04-Sep-2007 06:29:00'

OutputDate OutputValue

09/01/2007 22:30:00 3311.10145501792

09/02/2007 22:30:00 3299.85427066684

This is unique to my machine, the same query in a different machine returns me the correct data

OutputDate OutputValue

09/02/2007 06:30:00 3311.10145501792

09/03/2007 06:30:00 3299.85427066684

As you can see the data is correct but the dates are not

I have noticed that my log fifiles have a timestamp that is 9 hours out (GMT) could this be affecting the return values ?

Any ideas greatly appreciated

Not what you were looking for? View more on this topic or Ask a question