usql icon indicating copy to clipboard operation
usql copied to clipboard

Published 20 hours ago • verified publisher icon Azure

Outputters.Csv() formatting of DateTime datatype

Open capitanou opened this issue 7 years ago • 1 comments

Has there be a change recently to the CSV Outputter in the way DateTime data types are formatted to a string. Previous USQL jobs were outputting dates in the format of "2009-02-09T13:50:31.0000000". Execution of a job today is now Outputting "2009-02-09T13:50:31.0000000-07:00" ?

capitanou avatar Apr 20 '17 01:04 capitanou

Hmmm... Let me check. While our data centers run in UTC-7 timezones, the datatype value does not contain a timezone.

MikeRys avatar Apr 28 '17 18:04 MikeRys