ISO Date Format Conversion

subramanya · Post by **subramanya** » Wed Jul 29, 2009 11:53 pm

Hi,

Is there any function to convert the current DateTimestamp into the following ISO date format: 2009-07-29T11:20:32.0Z

Thanks

ray.wurlod · Post by **ray.wurlod** » Thu Jul 30, 2009 12:17 am

Which ISO standard specifies that format? What is "0Z"?

ISO 8601 (date and time formats) specifies YYYY-MM-DD HH:MM:SS with optional fractional seconds for a timestamp).

Conversion is only relevant if the target is a string data type.

chulett · Post by **chulett** » Thu Jul 30, 2009 12:31 am

Apparently that's a Java implementation of an "ISO 8601" format and I keep seeing search results calling it a SimpleDateFormat. For example, go here and scroll down to Method Detail and the isoFormat entry. The 'Z' seems to be a timezone offset.

subramanya · Post by **subramanya** » Thu Jul 30, 2009 12:32 am

Thanks for the reply

ray.wurlod wrote:Which ISO standard specifies that format?

Not sure. My guess is that this is an extended format for ISO 8601.

ray.wurlod wrote:What is "0Z"?

'Z' is the zone designator for the zero UTC (Coordinated Universal Time) offset.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 30, 2009 4:36 pm

OK, you're probably going to need a fairly complex expression to effect the conversion from local time to UTC if the solution needs to be general, or use a constant offset for a limited result. (Incidentally, how is Indian Standard Time (4.5 hours offset) represented?)

The rest should just be decomposing the string, adjusting the hour (and, possibly, the day), then re-assembling the string. Should be able to do it all in stage variables.

anu123 · Post by **anu123** » Wed Sep 15, 2010 11:47 am

subramanya

Did you find a solution? We have a requirement to convert UTC datatime into EST and load into a DB2 table.

It would great if you can share the solution.

Thanks in advance.