Re: Difference in times - Oracle DB and forms

[Michiel Beijen]

** I guess you are right on the DB time zone thing.
This will make it a 'best practice' to set your server to GMT, especially if you are working in a global environment.
It would be an enhancement request to let the server store gmt by default, regardless of the server timezone setting.

--
Michiel

On 9/1/06, McKenzie, James J C-E LCMC HQISEC/L3 <[EMAIL PROTECTED]> wrote:

**

Michiel:
 
Huh?  The time stored in the database is the same TZ as the ARS server from what I've been able to determine.  However, that being set aside you do have a point.  If you look at the time on the WUT, it will be the same as the user machine.  But if you run an external process to the server, the time displayed will be the server's time and NOT the user local time, unless you use processes to grab the user's local time and then adjust for the difference between the two.  This has resulted in some interesting time differences and a lot of work to correct. 

I would be very happy if the database did store times in UTC/GMT.  It would make some of the things I do much easier.
 
James Mckenzie

________________________________

From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Michiel Beijen
Sent: Friday, September 01, 2006 3:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Difference in times - Oracle DB and forms

** The Windows Remedy User tool takes your local timezone, which is set in the Windows Control Panel, into account. This includes daylight saving time if applicable as well.

The value stored in the database is GMT.

Does this help you?

Kind regards,

Michiel

On 9/1/06, Mark Bee <[EMAIL PROTECTED]> wrote:

        Hi all,
        The HPD-HelpDesk fields display an actual time whilst
        after recalculating the database's time I got 2 hour delay.
        It concerns all date fields (arrival time, resolved time, work in progres
        time...).
       
        When I check database time zone:
        select dbtimezone from dual;
        it gives me
        +02:00
        on the other Remedy server I got:
        -07:00
        But still the difference is 2 hours.
       
        I think it's an Oracle issue, perhaps wrong configuration.
        Can anyone point me to the solvation.
        Tanks
        Mark B.
       
        _______________________________________________________________________________

        UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
       

__20060125_______________________This posting was submitted with HTML in it___

__20060125_______________________This posting was submitted with HTML in it___

__20060125_______________________This posting was submitted with HTML in it___