Re: Time differences?

From: Lee Levy <levy.lee.ls_at_bhp.com.au>
Date: 1996/03/19
Message-ID: <4il27g$cf3_at_gossamer.itmel.bhp.com.au>#1/1

In article <314E010A.2EFA_at_mbox.digsys.bg>, Ognian Nikolov <csoft_at_mbox.digsys.bg> says:
>After the SQL*Plus command
>SQL>SELECT TO_CHAR(SYSDATE,'DD/MM/YYYY HH24:MM:SS') FROM DUAL;
>we are getting the time from Oracle NT WGS2000 and this time is different
>from the displayed time after
>SQL>SET TIME ON
>When logged to NT we have a logon script synchronizing workstation time
>with the server.
>
>The peculiarity is that the minutes in both times are always '03' and the
>times are different.
>
>What is the reason? Is it a bug or we rae misunderstanding something?
>
We had a similar problem but I think it went to 0, not 3. Try a format mask of DD/MM/YYYY FMFXHH24:MM:SS (from memory), instead. Check the impact too, to ensure it suits you, but it does stop this bug (assuming your cause is the same as ours)

HIH
Lee

----------------+---------------------------------------------------
      This      |  Lee Levy, ISSD Systems Development, Del Code (34)
     space      |  BHP Information Technology,  ACN 006 476 213
  left blank    |  PO Box 261, Warrawong, NSW 2502, Australia

 intentionally | PH: +61 42 75-5485 Fax: -5500 Tie: 8855-   in mourning | Internet : levy.lee.ls_at_bhp.com.au

----------------+---------------------------------------------------

Opinions expressed are mostly my own, so give me some credit. Received on Tue Mar 19 1996 - 00:00:00 CET