Re: Question regard dates in Oracle database.

/ hpcc01:comp.databases.oracle / tkyte_at_us.oracle.com (Thomas J Kyte) / 7:10 pm Mar 25, 1996 /

> I still think Oracle has a problem (solved in most other DBMS).
|Which ones and how?

    I apologize and take it back. I must be thinking of something else.     I did have my own solution using other databases, but not using something     offered by the DBMS as my post implied.

>   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) ?
 

|Scenario 2:
|
|I forget to do something my boss said to do by COB.
|He/She said to do it by 5pm or else.
|It is now 11pm, I didn't do it.
|I set the system clock on my pc to 4:30pm and execute the transaction.
|Wah-lah, the system thinks I did my work at 4:30pm.
|
|Doesn't it look odd to my boss the next when they KNOW they looked at 6pm to see
|if I did it (and I hadn't) but then the next day it says I did at 4:30pm?
|
|Relying on the client machine to provide the correct date is a fatal error (and
|a security risk, and error prone, and so on).....
|
|I can make my workstation say anytime I want, anytime I want it to. I can
|'fake' things.
|
|Wouldn't it be stranger to your your DBA in japan or germany that all accesses
|take place between 9am and 5pm their time? I kinda think that a server in
|ANYWHERE expecting hits from EVERYWHERE would be expecting hits 24 hours a day.

   This is assuming you LET the user alter/fix a date. This is inviting fraud.    In some applications, they designed this "feature" in.    For example, on the 31st of February, a warehouse tries to meet its quarterly    shipping target by bringing in more workers and more trucks. They work after    midnight and into the early morning. They want those shipments reported    as February' shipments, not March's.
   They way I would do it is have the computer generate the transaction date    based on a logic that takes work date/time into consideration, instead    of having the user enter which ever date/time he/she wishes. Received on Tue Mar 26 1996 - 00:00:00 CET