RedTailAgriTech.com - Dead Zones & Cow Spooks

SELECT TOP (3000)
    seq,
    utcts,
    created_at,
    lat,
    lon,
    state,
    /* + = created_at occurs AFTER utcts, − = BEFORE */
    DATEDIFF(
        MILLISECOND,
        (utcts AT TIME ZONE 'UTC'),
        ((created_at AT TIME ZONE 'Mountain Standard Time') AT TIME ZONE 'UTC')
    ) AS diff_ms_utc_vs_local
FROM dbo.kettle
WHERE dtype = 'Collar'
  AND created_at >= '2025-10-22T19:43:08'
ORDER BY created_at desc;