ISO format Date

michel.baldellon · April 4, 2018, 5:23am

Hi,

In an Opendata database, date are encoded in this iso format (http://www.w3.org/TR/NOTE-datetime) :
Complete date plus hours, minutes and seconds:
YYYY-MM-DDThh:mm:ssTZD (eg 1997-07-16T19:20:30+01:00)

in my case :
2014-08-09T14:20:21+02:00

A “Convert Data Type > Text to Date transformation” failed.
Any other options?

Best regards,
Michel

dgudkov · April 4, 2018, 3:24pm

Hi Michel,

use format yyyy-MM-ddTHH:mm:sszzz in the “Convert Data Type” transformation.

michel.baldellon · April 4, 2018, 5:04pm

Thank’s for your rapid answer, as usual.
Always less than 24 hours for an answer, hats off!

dgudkov · April 4, 2018, 5:18pm

You’re welcome, Michel.

michel.baldellon · April 5, 2018, 8:42am

Hi Dmitry,
Perhaps you could add on day this format in the autodetect...
Best,
Michel

dgudkov · April 5, 2018, 12:54pm

Already added. It will work in autodetect starting from v3.8. Not only this but all ISO date formats with timezones and fractions of seconds.

michel.baldellon · April 5, 2018, 1:51pm

Great !!!
I like the continuous improvement of EasyMorph!