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.
"U-SQL’s built-in extractors normalize all date time values to UTC -07:00 and then drop timezone information if present."