Convert Extended Event action mdmget_TimeStampUTC to datetime
1
vote
1
answer
394
views
SQL Server Extended Events can include an action of
mdmtargetpkg.mdmget_TimeStampUTC
. It returns a value such as 132085458320550473. How can that be converted to an actual date?
It doesn't appear to be a valid Unix timestamp, even using microseconds.
@@VERSION
:
-none
Microsoft SQL Azure (RTM) - 12.0.2000.8
Jul 3 2019 10:02:53
Copyright (C) 2019 Microsoft Corporation
Asked by Riley Major
(1965 rep)
Jul 25, 2019, 04:48 PM
Last activity: Jan 23, 2025, 08:06 PM
Last activity: Jan 23, 2025, 08:06 PM