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.
Timestamp to Varchar conversion
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 30
- Joined: Wed May 15, 2013 1:22 am
- Location: Bangalore
Timestamp to Varchar conversion
Cheers,
Schindler
Schindler