DateFromString Function

[Rajesekhar]

Hi Iam trying to convert String to Date using Modify Stage.

And the function which iam using is

Date:Date=date_from_string[%mmm %dd, %yyyy](Date)

My input format is of string and is like June 14, 2010

when I run this it gives a warning saying

Data string 'June 14, 201' does not match format '%mmm %dd, %yyyy': an integer was expected to match tag %dd.

What is this warning, how to resolve this please help!!

-thanks, Raj.

[ray.wurlod]

"%mmm" matches the three-character abbreviation of the month name.

You need to research the correct formulation in the date format picture. From memory - because I can't check at the moment, the full month name is pictured by "%mmmm".

[rameshkm]

Hi Rajeseaker,
You mention as Date:Date= What is the first Date mean is it the column name , if yes please change the Column name because The Date is datatype so it not accept as column name, the correct syntax is

Source _ColumnName:datatype =date_from_string(Destination column name["%mmm %dd, %yyyy"]
Let me know if it work

[Sreenivasulu]

I think you need training in 'datastage'.

[antonyraj.deva]

As pointed by Ray, for full month name %mmmm should be specified.

"%mmm" will give January as Jan, September as Sep etc,.

So the code for your requirement is

Code: Select all

Source _ColumnName:datatype =date_from_string(Destination column name["%mmmm%dd, %yyyy"]