Hi
system date its format time stamp in source system, we need characteristic format in target system, in order that timestamp only year and month, please advice me how can we get this one
Time stamp
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 22
- Joined: Mon Oct 10, 2005 10:11 am
- Location: u.s.a
- Contact:
Time stamp
hi
i want to learn datastage which was use ful for emprove my skills
i want to learn datastage which was use ful for emprove my skills
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The answer to the original question is "extract the year and month from the timestamp". If your source is standards-compliant, and the timestamp conforms to ISO 8601, then the first seven characters of the timestamp contain the year and month. Because server jobs have no internal data types, it would be sufficent to use Left() or Substrings() to extract the leftmost seven characters. To remove the delimiter character ("-") you could use Convert() or Oconv() function.
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.