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
(thinking…)
Sign in with: Microsoft
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
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base