(wrong string) ’s new_time function is buggy?
From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Sun, 12 Dec 2010 15:47:12 -0800 (PST)
Message-ID: <641e4dbb-d9fd-4bfa-9b34-d734a28d9415_at_s5g2000yqm.googlegroups.com>
Prem ...
Date: Sun, 12 Dec 2010 15:47:12 -0800 (PST)
Message-ID: <641e4dbb-d9fd-4bfa-9b34-d734a28d9415_at_s5g2000yqm.googlegroups.com>
Prem ...
# select extract(timezone_hour from systimestamp) from dual;
... and returns 5 today. Will it return me 4 in March or so when new day light goes in effect.
Well of course one possibility is actually reading the relevant and free Oracle documentation for the release you are running. Received on Sun Dec 12 2010 - 17:47:12 CST