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___
