convert date function

[halpavan2]

Hello,

Can you please in coverting my date fuction.

My input is dataset --- transformer ---- DB2 stage.

Input is varchar field and output is date field

date coming from source is mm/dd/yyyy and i need to convert this to yyyy-mm-dd.

Ay help is much appreciated.

Thanks
Pavan

[pandeesh]

Hi, there are a lot of examples recently given for StringToDate conversion.
Please check those posts.
Still if you have any doubts, please let us know.

[halpavan2]

Hi, there are a lot of examples recently given for StringToDate conversion.
Please check those posts.
Still if you have any doubts, please let us know.

Yeah.. i have see those posts..and applied the logic but still geeting the error

I haved the function like this StringToDate(Column name,"%mm/%dd/%yyyy")

here is the error

APT_CombinedOperatorController,2: Data string '2/28/2012' does not match format '%mm/%dd/%yyyy': the value for tag %mm has fewer characters than expected.

Please help me how to fix this.....

[pandeesh]

Its clear that your input string doesn't match the format you specified .
Use single %m in the format .

[premupdate]

Try StringToDate(Column name,"%(m,s)/%dd/%yyyy")

It might work..

[pandeesh]

Try StringToDate(Column name,"%(m,s)/%dd/%yyyy")

It might work..

I am curious what does that 's' in %(m,s) mean?
In his case, i believe the below will work:

Code: Select all

StringToDate(Column name,"%m/%dd/%yyyy")

(or)

Code: Select all

StringToDate(Column name,"%m/%d/%yyyy")

i think the second one has been tested by James recently.

Thanks

[halpavan2]

Try StringToDate(Column name,"%(m,s)/%dd/%yyyy")

It might work..

Hi,

I used this function StringToDate(Column name,"%(m,s)/%dd/%yyyy") and it worked for me....thanks for that..... i haved read what 's' specifies and it specify this option to allow leading spaces in date formats.

Thanks again.

[premupdate]

%(m,s)

indicates a numeric month of year field in which values can contain leading spaces or zeroes and be one or two characters wide.

[pandeesh]

Thanks for your info..