var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: issue to current time
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 ?
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?
Talk to DBA how they are install DB2 system.
Originally Posted by alanhome
They are made a mistake.
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.
Tags for this Thread