Home

Conversion of epoch / unixtimestamps within Log Analytics

Matthias Stier
Occasional Visitor

 we re using a lot of epoch / unixtimestamps (seconds since 1970-1-1) in our solution and are wondering right now if there is the possibilty to convert those timestamps to datetime objects within loganalytics queries? Unfortunately we couldn't find anything in the documentation on that matter. Would be great if someone could point us in the right direction.

2 Replies
Highlighted

Hi @Matthias Stier 
I'm exactly looking for the same solution. Please let me know, if you found out anything helpful!

maybe?

 

datatable (unixtime:string)
[
915148798.75,
915148799.00,
915148799.25,
915148799.50,
915148799.75
]
| project todatetime(unixtime)
 
 
// line 1 of the result would be "1998-12-31T23:59:58.000" 
 
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
203 Replies