Hi all,
I'm trying to do conversion from string to time.In the input i'm having HOUR_OF_DAY(varchar) nullability as null.first i need to handle null values and then want to convert.
In th input i'm having values as
HOUR_OF_DAY
4:00Am
8:00pm
6:00pm
9:00pm
like wise i'm getting spaces in between.How can I handle these space values.
Please anyone suggest me how to do this?
Thanks,
Kalpana.
Handle_null() using modify stage
Moderators: chulett, rschirm, roy
Handle_null() using modify stage
Kalpana Marupudi
-
- Participant
- Posts: 11
- Joined: Fri May 29, 2009 9:54 pm
- Location: hyd
Re: Handle_null() using modify stage
hi
we can use handle_null(columname,value) in modify stage
we can use handle_null(columname,value) in modify stage