Converting string to date in modify stage
Posted: Mon Jun 15, 2009 5:17 am
Hi,
I wanted to convert one varchar field into date field using the modify stage. My input field is in the dd-mm-yyyy format and I used the below specification in the modify stage.
in_col:date = date_from_string "%dd-%mm-%yyyy"(in_col)
But I am getting the below error while running the job.
main_program: Error parsing modify adapter: Expected ';' or end, got: "%dd-%mm-%yyyy""
Expected destination field selector, got: ")"; input:
Dt_of_extrcn:date = date_from_string "%dd-%mm-%yyyy"(Dt_of_extrcn)
;
Please help me to resolve this issue.
Thanks
I wanted to convert one varchar field into date field using the modify stage. My input field is in the dd-mm-yyyy format and I used the below specification in the modify stage.
in_col:date = date_from_string "%dd-%mm-%yyyy"(in_col)
But I am getting the below error while running the job.
main_program: Error parsing modify adapter: Expected ';' or end, got: "%dd-%mm-%yyyy""
Expected destination field selector, got: ")"; input:
Dt_of_extrcn:date = date_from_string "%dd-%mm-%yyyy"(Dt_of_extrcn)
;
Please help me to resolve this issue.
Thanks