Time formatting assistance on SWQL Query - Down Nodes with Down TIme

bobmarley

When I run this query is displays the downtime five in the future of my current time, which happens to coincide with GMT so I think the

database table is in GMT. Could anyone assist with the code to transform this the EST ? 

SELECT
NodeName AS [Node Name],
'/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Node Name],
DetailsUrl AS [_LinkFor_Node Name],
MAX(DOWNEVENT.EVENTTIME) AS [DOWN TIME]
FROM ORION.NODES NODES
INNER JOIN ORION.EVENTS DOWNEVENT
ON NODES.NODEID = DOWNEVENT.NETWORKNODE
WHERE STATUS = 2 
GROUP BY NodeName, StatusIcon, DetailsUrl
ORDER BY NodeName

christopher.t.jones123

@bobmarley you should be change your select for DOWN TIME to below and it will convert the time to your local time. 

MAX(tolocal(DOWNEVENT.EVENTTIME)) AS [DOWN TIME]