Timestamp difference
Moderators: chulett, rschirm, roy
Timestamp difference
I am using the TIMESTAMPDIFF in my DB2stage to check the difference between the current timestamp and another timestamp....It seems that the result is only estimated as it considers the number of days a year as 365...Any other solution to this..? What about Days(ts1)- Days(ts2) ?
It depends where you wish to compute this numeric difference. If you load the timestamp into DataStage and convert it into internal format you can subtract the two values to get an exact difference in days.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Look here for example server routines. Right click and choose Save As to download.
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.