Type Conversion Using Modify Stage
Posted: Thu Apr 20, 2006 3:04 am
Hi
I tried using Modify Stage for converting varchar to Date using below conversion specification :
new_date : date = StringToDate(old_date,"%yyyy-%mm-%dd")
But it gives error saying :
main_program: Error parsing modify adapter: Error in binding: Unknown conversion: StringToDate
Expected destination field selector, got: ")"; input:
new_date : date = StringToDate(old_date,"%yyyy-%mm-%dd")
But same function works when i use tht in Transformer Stage.
Why is it so.
Amit
I tried using Modify Stage for converting varchar to Date using below conversion specification :
new_date : date = StringToDate(old_date,"%yyyy-%mm-%dd")
But it gives error saying :
main_program: Error parsing modify adapter: Error in binding: Unknown conversion: StringToDate
Expected destination field selector, got: ")"; input:
new_date : date = StringToDate(old_date,"%yyyy-%mm-%dd")
But same function works when i use tht in Transformer Stage.
Why is it so.
Amit