Seconds from timestamp
Posted: Wed Nov 16, 2011 1:11 pm
I need seconds from timestamp i am using the function
SecondsSinceFromTimestamp(svCSOUTTSA, svCSINVTSA) but i am not getting the currect result.
when the difference between the two is very high
ie : 2011-07-01 15:27:00 --- 2011-08-23 17:41:00 ---- 4587240 i am getting
4500840 when i use the db2 function (timestampdiff(2,truck_leave_tsp - invoice_print_tsp)) i get this result which is correct .
If the two dates are in same month i am getting the currect result when i use the datastage function.
is there any function which i can use to get the currect result in datastage.
SecondsSinceFromTimestamp(svCSOUTTSA, svCSINVTSA) but i am not getting the currect result.
when the difference between the two is very high
ie : 2011-07-01 15:27:00 --- 2011-08-23 17:41:00 ---- 4587240 i am getting
4500840 when i use the db2 function (timestampdiff(2,truck_leave_tsp - invoice_print_tsp)) i get this result which is correct .
If the two dates are in same month i am getting the currect result when i use the datastage function.
is there any function which i can use to get the currect result in datastage.