Latest Activity


UTC date time field conversion - add hour VERSUS convert time zone - yield different result over daylight saving dates.

Hi, Need to understand why the two do not produce the same values when a UTC date/time field crosses over a change of daylight savings on lst March the 12th. Thanks. VQL SELECT "Event Time UTC" AS "A" ,formatdate('HH:mm:ss', convert_timezone('UTC', ...

UTC; addhour; convert_timezone