Hello all,

I have a problem when I use current time - current timezone in my SQL statement. I got the result e.g. 17:26, but correct answer is 16:27 which is my pc system time.

I have no idea why

can anyone help me on this ?

thanks

In general, divide and conquer to solve a problem.

First see the values of current time and current timezone separately.

thanks for reply.
I got 19:27 if I use current time, but now is 16:27, 3 hours later
I got 20000 by using current time and my database uses UTC.

Now I use current time - current timezone - 1 Hour to get local time, but it is hard code
How can I fix it?

thanks

Talk to DBA how they are install DB2 system.
They are made a mistake.

Lenny

thanks, I will .

Current time and current timezone are the values on the server. If the server is using GMT, then subtracting current timezone only gives you the local time of the server, not the workstation.

Andy