How can we improve Microsoft Azure Data Lake?

Extract datetime using built in extractors with a timezone other than UTC-7

The built in extractors' current behaviour when extracting DateTime columns always set the timezone to UTC-7. It would be very helpful to have a way of extracting DateTime columns without setting the timezone to UTC-7. The current behaviour is not what users in my organisation anticipate and causes unexpected results when comparing date times.

I am aware that it is possible to work around this issue, by extracting a string and performing the conversion afterwards.

https://msdn.microsoft.com/en-us/library/azure/mt621366.aspx
"U-SQL’s built-in extractors normalize all date time values to UTC -07:00 and then drop timezone information if present."

15 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Hugh shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base