Need help to insert " AddHour +5 " in Uptime result

makecrazy, if the goal is to convert the returned time result to a local timezone you can also just use the tolocal function in SWQL. 

issue is that swql giving me node up/down time which is lesser than 5 hours from down/up event actual time.

giving error

makecrazy, my bad, forgot to alias out the selection in that. Try this

(
SELECT TOP 1 tostring(tolocal(EndTime.EventTime)) AS UpTime
FROM Orion.Events AS Endtime
WHERE tolocal(EndTime.EventTime) > tolocal(StartTime.EventTime)
AND EndTime.EventType = 5
AND EndTime.NetObjectType = 'N'
AND EndTime.NetworkNode = StartTime.NetworkNode
ORDER BY tolocal(EndTime.EventTime)
) AS UpTime

now this error

makecrazy, so I don't have an instance I can mess around and test a query. so what I have provided will conceptually work, you just need to fine-tune the syntax errors I have given you. Normally I would work that out before I gave it to you. I think the issue is with the order by in that subquery, but without an instance to confirm it's just a feeling.

ok , thanks for urs support

m-milligan

 KMSigma

can u help me on this.

Can you work out which line is causing the issue by adding and removing the  -  - 

Dear 

not expert in scripting that's why need help on adding +5 Hours in Node Uptime

(
SELECT TOP 1 EndTime.EventTime
FROM Orion.Events AS Endtime
WHERE EndTime.EventTime > StartTime.EventTime
AND EndTime.EventType = 5
AND EndTime.NetObjectType = 'N'
AND EndTime.NetworkNode = StartTime.NetworkNode
ORDER BY EndTime.EventTime
) AS UpTime,

ADDHOUR(5,(
SELECT TOP 1 EndTime.EventTime
FROM Orion.Events AS Endtime
WHERE EndTime.EventTime > StartTime.EventTime
AND EndTime.EventType = 5
AND EndTime.NetObjectType = 'N'
AND EndTime.NetworkNode = StartTime.NetworkNode
ORDER BY EndTime.EventTime
)) AS UpTime,

Thanks dear,

it provided my desired result.

Thanks dear,

it provided my desired result.