Timestamp difference

cosec · Post by **cosec** » Sun Jul 01, 2007 8:49 pm

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) ?

ArndW · Post by **ArndW** » Sun Jul 01, 2007 10:18 pm

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.

ray.wurlod · Post by **ray.wurlod** » Mon Jul 02, 2007 9:05 am

Look here for example server routines. Right click and choose Save As to download.