not able to convert string to time stamp

[srini27]

Hi,
I am working on IIS 8.7

SRC : Seq file stage

target: Oracle connector

Source file is having the fields CRET_DT : 08-MAR-13 and MOD_DT :15-MAR-13.


I am using StringToDate(DSLink4.CRE_DTTM,"%dd-%mon-%yy").but its giving following error.

Transformer_7,0: Data string '08-MAR-13' does not match format '%dd-%mon-%yy': an integer was expected to match tag %m

Please help me out on this.

[jwiles]

Check the validity of your format string against the specifications in the product documentation. Pay close attention to the valid formats for month.

Date Formats

Regards,

[chandra.shekhar@tcs.com]

Use

Code: Select all

StringToDate(DSLink4.CRE_DTTM,"%dd-%mmm-%yy")

[srini27]

Thanks alot chandra. It works fine.

[chulett]

Which you would have seen if you'd followed the link James posted and read the actual formats needed rather than assume it was the same as Oracle or whatever other tool you are used to.