Originally posted by: SystemAdmin

I am trying to take a text value of

2005-02-03T13:24:39.936-07

and using the TODATETIME function convert it to, obviously, a date/time value keeping everything as is. Not as easy as it sounds however. I'm not sure why. The TODATETIME function doesn't seem to be acting as is described in the documentation. I'm not getting anything in my output. Anyone got any ideas? Here is my rule as it currently stands. This isn't working though.

= TODATETIME ( INPUT, "{CCYY-MM-DD}T{HH24:MM:SShttp://.0-6+/-ZZ:ZZ}" )

Thanks,
Matt
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Your string looks right to me.

Couple suggestions:

1. Replace input with a hard coded string and see if it converts. If it doesn't, send the case to support. If it does, your input value may not be what you think.

2.Check the value of INPUT by writing it out to a file as OutputElement="(" + INPUT + ")"

This will highlight if there are any extra characters and that it matches your string.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

What version of the software are you using? There is a known bug with Ascential Datastage TX 6.7.1 and the TODATETIME function (returns no output).
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

FYI. This was a bug in the software. If any of you encounter this issue, contact Ascential support. They now have a replacement .dll available.

Matt
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender