How can I convert a string into a date?

[pavankatra]

Hi,
my input is 26-feb-2010,i am reading as varchar in the source

Now i want to populate into date column.

i was used below function
StringToDate(Trim(lk_read.expiry_date),"%yyyy-%mmm-%dd").

after executing the job i am getting output as astroids(*********)

Can anyone pleaase help me to sort out the issue.

Thanks in advance.

[ArndW]

Your date format is incorrect, it should read "%dd-%mmm%-%yyyy"

[pavankatra]

Your date format is incorrect, it should read "%dd-%mmm%-%yyyy" ...

thank you for your reply

i was tried ,but its not working.

[ArndW]

I just noticed a typographical error on my part, the format should be
"%dd-%mmm-%yyyy"

[pavankatra]

Your date format is incorrect, it should read "%dd-%mmm%-%yyyy" ...

thank you for your reply

i was tried ,but its not working.

there was space issue with the date,so trim the data and then applied the type conversion function.Now its working fine

Thanks for your support.