Convert Local TSD in UTC
Posted: Fri Jan 14, 2011 10:32 am
Hi,
i have to build a loadfile for DB2 Load-Utility with DFSort. So far no problem. But in the origin file is a timestamp (extract from Oracel) as local TSD with a offset
(difference to UTC). Store should be the TSD as UTC TSD.
example: local TSD with offset 1:30
2011-11-01T03:04:5:678-1:30
result should be : 2011-11-01-03-04.05.678000 - 1.5 = 2011-11-01-01-34.05.678000
It is possible to do this conversion with DFSORT? How can i subtract the offset from the origin TSD?
Regards
i have to build a loadfile for DB2 Load-Utility with DFSort. So far no problem. But in the origin file is a timestamp (extract from Oracel) as local TSD with a offset
(difference to UTC). Store should be the TSD as UTC TSD.
example: local TSD with offset 1:30
2011-11-01T03:04:5:678-1:30
result should be : 2011-11-01-03-04.05.678000 - 1.5 = 2011-11-01-01-34.05.678000
It is possible to do this conversion with DFSORT? How can i subtract the offset from the origin TSD?
Regards