Please anyone explain me the use of below in kusto query language

Kumari, Nidhi (Cognizant) 20 Reputation points
2023-04-18T17:52:35.7866667+00:00

Please anyone explain me the use of tolong function in below kusto query language tolong(impactstarttime) >1

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
{count} votes

1 answer

Sort by: Most helpful
  1. Boris Von Dahle 3,221 Reputation points
    2023-04-18T18:33:47.5366667+00:00

    Hello,

    The tolong() function in Kusto Query Language (KQL) is used to convert a numeric or datetime expression to a long integer (Int64). In the context of your provided query, it's being used to convert the impactstarttime value to a long integer and check if is greater than 1.

    https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/tolongfunction By example : | where tolong(impactstarttime) > 1


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.