The most recent content from our members.
What is the SQL syntax to convert a UTC date/time, such as in the datetime field for a unDP (universal device poller)? I keep getting: MACRO SQL ERROR - Incorrect syntax near '7'. for this statement: Local time: ${SQL:Select DATEADD(hh,DATEDIFF(hh, GETUTCDATE(), GETDATE()),('''' + ${CustomPollerStatus.DateTime} + ''''))}…
It looks like you're new here. Sign in or register to get started.