4

How would I project the unix timestamp for when my data was logged in Azure through Azure App Insights? I know I can use now() to get the current timestamp, but what about the timestamp of a row?

John Gardner
  • 24,225
  • 5
  • 58
  • 76
perennial_
  • 1,798
  • 2
  • 26
  • 41

1 Answers1

6

Every table in AppInsights has a "timestamp" column, which marks when the event occurred.

In order to convert to Unix timestamp, try this:

requests
| take 1
| project unixtime = tolong(timestamp - datetime(1970-01-01)) / 10000000
Assaf Neufeld
  • 703
  • 5
  • 10