Re: Question regard dates in Oracle database.
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