Altering session time zone...

From: Miggins <mtproc_at_yahoo.co.uk>
Date: 9 Aug 2005 09:59:04 -0700
Message-ID: <1123606743.978289.106880@z14g2000cwz.googlegroups.com>

Hi,

Am trying to alter a seesion time zone so that when a user logs on or connects through the running of a report their location can be checked and a timezone offset applied to that session.

Using ALTER SESSION SET TIME_ZONE='+5:00'; has no effect whatsoever. Should not selecting SYSDATE have the offset between DBTIMEZONE and SESSIONTIMEZONE applied.

Eg DBTIMEZONE = '+1:00' SESSIONTIMEZONE = '+5:00'

Therefore if at 17:00 "select to_char(sysdate,'HH24:MI') from dual;" is issued then I would expect the time returned would be 21:00, but it isnt

Any ideas?

Cheers Received on Tue Aug 09 2005 - 11:59:04 CDT