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
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    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
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      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