Modify Stage-Type conversion from string to date

bala_135 · Post by **bala_135** » Thu Jul 06, 2006 12:30 am

Hi,

I need to convert a input field which is string to date.Eg(1/12/2006).
I am using the function date_from_string(input column)..I am getting a fatal error.But when i use a proper date like 2006/12/01 the function is working fine.How to solve this problem.

Regards,
Bala.

bchau · Post by **bchau** » Thu Jul 06, 2006 12:55 am

Try date_from_string[%dd-%mm-%yyyy](input column)

ray.wurlod · Post by **ray.wurlod** » Thu Jul 06, 2006 1:53 am

The format string may need to be "%mm/%dd/%yyyy" (note the use of "/" as the separator character, to match the data) and it may be necessary to guarantee the leading zero on the month and day components.

bchau · Post by **bchau** » Thu Jul 06, 2006 2:06 am

oops my bad ray, i missed that. Thank you for the correction

bala_135 · Post by **bala_135** » Thu Jul 06, 2006 2:54 am

Hi Ray/bachu,

Thank you very much its working fine for the records which has got the exact format(%mm/%dd/%yyyy)but in my source i am having some records like 1/1/2006(month,date,year) here the month and date are not in the proper format so it issues a null in the target.

Regards,
Bala.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 06, 2006 5:47 am

Read again "and it may be necessary to guarantee the leading zero on the month and day components". Use substring, concatenation and If constructs to get the format right.