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
Converting Aug 2 1958 12:00AM to 1958-08-02 12:00:00
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 59
- Joined: Wed Dec 31, 2008 5:49 am
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
-
- Participant
- Posts: 59
- Joined: Wed Dec 31, 2008 5:49 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')"
In your case you need to convert the VarChar into Timestamp using something like "StringToTimeStamp(In.StringColumn,'%MMM %dd %YYYY %HH:%nn%aa')"
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>