Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Sysdate doesn't agree with date on Server
If this were Unix I'd tell you you probably started the instance with the
wrong time zone set (on the Unix-level that is, being directed by the TZ
variable). I suppose something similar can happen on VMS.
hth,
Peter
"Andrew" <andyho99_at_yahoo.com> schreef in bericht
news:8882aa3c.0301131104.26733a1e_at_posting.google.com...
> I saw a old archive with the problem I am having right now but it did
> not show the solution.
>
> In my case, the os is open/vms and the Oracle server is 8i.
>
> In VMS:
>
> DKB300:show time
> 13-JAN-2003 13:57:40
>
> In Oracle:
> select to_char(sysdate, 'yyyy/mm/dd hh24:mi:ss') from dual;
>
> TO_CHAR(SYSDATE,'YY
> -------------------
> 2003/01/13 12:57:40
>
> How can I make both times in sync?
>
> BTW, I tried to experiment in Oracle 9i by issuing sql:
>
> SQL> ALTER DATABASE SET TIME_ZONE = '-05:00';
> ALTER DATABASE SET TIME_ZONE = '-05:00'
> *
> ERROR at line 1:
> ORA-02231: missing or invalid option to ALTER DATABASE
>
> This example is from Oracle Metalink. I don't know why it doeen't
> work. Thanks.
Received on Tue Jan 14 2003 - 02:11:51 CST