Timestamp to Varchar conversion

[aschindler]

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.

[chulett]

Can you post your actual (full) unedited error? And your example shows "MMDDYYYY" format, why are you using "YYYYMMDD" in your conversion? If your input is an actual timestamp you should be able to use TimestampToString() directly.