The datetime output is identical to that of the E8601DTw.d format except for the T separator.
"yyyy-mm-dd hh:mm:ss.ffffff" instead of
A format generating the same output for date (and time?) variables would be useful too as some tools like Impala can only use timestamps, not dates.
I know this can be done using a picture format. Doing so makes the code a lot less portable though.
I'd suggest an additional moderator in the e8601 formats that controls the "T" character, similar to what can be done with some date formats:
yymmdd10. -> slashes
yymmddp10. -> dots
yymmddn8. -> no separators
PS and, oh yeah, the execrable Excel also can't read ISO standard formats. Well, what would one expect ...
@KurtBremser I agree. The plethora of 8601 formats could have been created this way as they mostly fiddle with separators and time zones. Not my call and useful either way.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.