How can we improve Microsoft Azure Data Lake?

Support columns of type TimeSpan

Currently USQL doesn't support columns of type TimeSpan, which means that:

1. In order to perform operations on TimeSpan values, or DateTime values, one needs to convert the TimeSpan to Ticks, perform the operation
2. 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)

18 votes
Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)

We’ll send you updates on this idea

Itay Sagui shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...
  • Ben commented  ·   ·  Flag as inappropriate

    What is the status of this request? We would like to create duration as well using USQL to create duration aggregates.

Feedback and Knowledge Base