Re: Question regard dates in Oracle database.

From: Suu Quan <quan_at_hpcc01.corp.hp.com>
Date: 1996/03/25
Message-ID: <56430019_at_hpcc01.corp.hp.com>#1/1


/ hpcc01:comp.databases.oracle / cfischer_at_nando.net (Chris Fischer) / 9:33 am Mar 21, 1996 /
>If I understand correctly, the multiple users from other timezones
>will be connecting to a central server running this application? If
>so, then time zone shouldn't be an issue because SYSDATE is the
>operating system date/time on the database server itself, not the
>client date/time on each PC or whatever.

   I still think Oracle has a problem (solved in most other DBMS).    Scenario : It's 11:30 AM California time. I -the client- enter a transaction with date -I think- is California "Monday 25 March 1996 at 11:30:10"

The server is in Germany (or Japan). The server registers a date-time of

     "Monday 25 March 1996 at 20:32:08" (well 2-second in overhead/delay) (or "Tuesday 26 March 1996 at 04:32:08" in Japan)

   Doesn't it look odd that somebody is working that late (or early) ? Received on Mon Mar 25 1996 - 00:00:00 CET

Original text of this message