Sample Header Ad - 728x90

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