Converting string to date in modify stage

[shukla_krishna]

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

[sambarand]

Try using this :

Dt_of_extrcn:date = date_from_string(Dt_of_extrcn)

Make sure the input data type is of Varchar and output data type is Date for this column .

[shukla_krishna]

Thanks Sam. It works.

But my input data is in the format dd-mm-yyyy. Can I convert a string in the format dd-mm-yyyy to date field.

[ray.wurlod]

What is your default date format string? It is is not "%dd-%mm-%yyyy" then you need to specify the date format string - inside square brackets - in the Specification in the Modify stage.

Code: Select all

date_from_string[%dd-%mm-%yyyy](inputcolumn)

Note also that this will not work if your date is not precisely this format, for example 16/6/2009 or 16-6-2009 or 16/06/2009 will not work, but 16-06-2009 will.