No. This is not an issue with the time Zone. This is to do regression testing to produce same result consistantly with same input data. Unfortunately, SYSDATE is also one of the input parameter. When I run the test case for the 2nd time, it produces different result. There is no automatic way whether the produced result is correct or not, unless I manually calculate each time I run the case and certify. If I could re-set the sysdate to the date and time, I ran the 1st case, then I am sure to produce same results all the time, then there is an automatic way to tell whether the test case is pass or fail. I am talking about such cases of about 2000 cases.
Each time, I release anything, I need to run these 2000 cases and certify, they are not affected.