Timestamp to Varchar conversion
Posted: Thu Jul 18, 2013 6:11 am
Hi Team,
I have requirement to convert timestamp to varchar.my source field is time stamp and target is varchar field.
input:07/18/2013 17:00:00
output:07182013
i'm getting desired ouput,but warnings are coming with error message:
conversion error calling conversion routine...
i had tried below options
TimestampToDecimal(Column,"%YYYY%MM%DD")
DateToString(TimestampToDate(Column),"%YYYY%MM%DD")
Please let me know how to get rid of warnings.
I have requirement to convert timestamp to varchar.my source field is time stamp and target is varchar field.
input:07/18/2013 17:00:00
output:07182013
i'm getting desired ouput,but warnings are coming with error message:
conversion error calling conversion routine...
i had tried below options
TimestampToDecimal(Column,"%YYYY%MM%DD")
DateToString(TimestampToDate(Column),"%YYYY%MM%DD")
Please let me know how to get rid of warnings.