About EasyMorph Tutorials & Examples Web-help

ISO format Date


#1

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


#2

Hi Michel,

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


#3

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


#4

You’re welcome, Michel.


#5

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


#6

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.


#7

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