Support columns of type TimeSpan
Currently USQL doesn't support columns of type TimeSpan, which means that:
- In order to perform operations on TimeSpan values, or DateTime values, one needs to convert the TimeSpan to Ticks, perform the operation
- Once we have the calculated value as Ticks, we can't convert it back to TimeSpan as a new columns (SELECT new TimeSpan(x) AS duration FROM Table)
Arif Febriyanto commented
Need help for this issue. What I really need is just to convert datetime to integer.
What is the status of this request? We would like to create duration as well using USQL to create duration aggregates.
Srini Parthasarathy commented
TimeSpan support is critical for temporal data processing; Native TimeSpan support will eliminate conversions;