With us being in a State that Changes Time with Daylight Savings. How do you keep your reports up to date without having to change them all -5,-6 hours?
We currently use:
SELECT
N.StatusLED as [Node Status]
,N.Caption as [Node Name]
,N.DetailsUrl as [Node URL]
,N.IPAddress as [IP Address]
,ADDDATE('hour',-5,A.TriggerTimeStamp) as [Went Down]
How could we alter this to where DayLight Savings would not effect the time shown and it would always show the correct time?
