Hi,
I have a datetime field defined as a varchar(20) and I need to convert it to a timestamp. The data coming in is from Teradata and is as follows:
10-MAY-2006 12:00:00
need to convert as
2006-05-10 12:00:00
I tried using StringToTimeStamp, but no luck. Any ideas how I can accomplish this?
Thanks,
Michael
Converting a datetime defines as varchar field to timestamp
Moderators: chulett, rschirm, roy