conversion of date(4) to timestamp(26)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
conversion of date(4) to timestamp(26)
HI I have a column of Date(4) and needed to convert in the transformer to timestamp(26)
Could any one give the syntax for this
Thanks in advance
thanks for your time
Suresh
Could any one give the syntax for this
Thanks in advance
thanks for your time
Suresh
Hi I have experience in parallel extender datastage I am ready to give/take help from other
hope we all help each other hand in hand
hope we all help each other hand in hand
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
Use DateToString() to convert your Date into a String, then StringToTimeStamp() to convert that string into a timestamp.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
Try doing things just one step at a time. What is the string output of for your data?
Code: Select all
DateToString(lnk_xfrm_column.UPDATE_DT)
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
StringToTimestamp(DateToString(lnk_Lkp_CustKy_out.UPDATE_DT),'yyyy-mm-dd hh:nn:ss')
I have date so If I convert it into string
I might get for eg 1999-11-05 is the date
and the corresponding string is "1999-11-05"
could you pls help me
thanks
I have date so If I convert it into string
I might get for eg 1999-11-05 is the date
and the corresponding string is "1999-11-05"
could you pls help me
thanks
Hi I have experience in parallel extender datastage I am ready to give/take help from other
hope we all help each other hand in hand
hope we all help each other hand in hand
karrisuresh wrote:...could you pls help me...
I'm trying to. Just do it bit by bit. What is the string output from my last post's suggestion? Is what you posted your result or just what you think the result ought to look like?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
date to string them string to timestamp
It should work. I used few days ago. Check your format %yyyy-%mm-%dd
changming - of course it cannot work. Which is why I am trying to get get the original poster to confirm his output.
hint: 1999-11-05 does not match the timestamp pattern 'yyyy-mm-dd hh:nn:ss'
hint: 1999-11-05 does not match the timestamp pattern 'yyyy-mm-dd hh:nn:ss'
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>