Converting Aug 2 1958 12:00AM to 1958-08-02 12:00:00

ravireddy25 · Post by **ravireddy25** » Fri Oct 12, 2012 12:35 am

HI,
From source the values are coming like below
May 30 1967 12:00AM
Aug 2 1958 12:00AM
i need to convert in to timestamp like 1958-08-02 12:00:00

if any one has any idea plz let me know ,

Thanks in Advance

chandra.shekhar@tcs.com · Fri Oct 12, 2012 1:14 am

If your source and target have Timestamp datatype then you need not to worry. The database will automatically handle it.
By the way, whats the source datatype ?

ravireddy25 · Post by **ravireddy25** » Fri Oct 12, 2012 1:36 am

Source data type is Varchar

ArndW · Post by **ArndW** » Fri Oct 12, 2012 2:18 am

Date and Timestamp columns have no intrinsic format. You only need a format when loading from another datatype or when converting to another datatype.

In your case you need to convert the VarChar into Timestamp using something like "StringToTimeStamp(In.StringColumn,'%MMM %dd %YYYY %HH:%nn%aa')"