This content has been marked as final. Show 2 replies
1 of 1 people found this helpful
Answered my own question with these threads:
The real issue was both SWQL use of CAST/CONVERT and the modifications for DATEADD.
This will convert in SWQL (UTC in my case):
ToUTC(AddSecond((0+<MYEPOCHTIME), DateTime('1970-01-01 00:00:00'))) as SyncTime_UTC
Actually drop "ToUTC" at the start of that - it was scrambling it up more.