Re: Question regard dates in Oracle database.

Ken Denny <kedenny_at_mail.concentric.net> wrote:

>This is working fine now, but I am concerned about the future. Right now
>everyone who uses the system is in the same time zone. I am wondering
>what it will be like when users in other time zones come on. This is
>UNIX so the operating system knows what time zone everyone is in, but I
>wonder if Oracle looks at that. Are dates stored in GMT or some kind of
>time zone-neutral format or will I have to write code to check what time
>zone I am running in and compensate for it in my code?

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.

+------------------------------------------------------------+
| Chris Fischer                           cfischer_at_nando.net |
| Sr. Systems Analyst                    Work: (919)676-0062 |
| Toys "R" Us                                                |
+------------------------------------------------------------+