Hi,
can anybody suggest me how to convert the Timestamp from db2 database to SQL server Db in Datastage server Edition.
YYYY-MM-DD HH:MI:SS.ssssss To YYYY-MM-DD HH:MI:SS.sss
Convert timestamp format
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 39
- Joined: Sat Jul 05, 2008 3:25 am
- Location: chennai
Convert timestamp format
MALLI MURALI
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
Left(InLink.TheLongTimestamp,23)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 39
- Joined: Sat Jul 05, 2008 3:25 am
- Location: chennai