Re: Time differences?

Ognian Nikolov <csoft_at_mbox.digsys.bg> wrote:

>Please help us in the following situation:
>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?
>
>Please send your suggestions or advices to: csoft_at_mbox.digsys.bg
>
>
>
>
>--
>=-=-=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
>CSoft Ltd., 8 "Filaret" str., 9000 Varna, Bulgaria
>tel. +35952-602844; fax: +35952-602843
>email: csoft_at_mbox.digsys.bg

A common mistake. MM is the format mask for MONTHS and MI is the format mask for MINUTES. If you run your query next month, it will return 04 in the "minute" position.  

-- 
Mike Morgan
Technology Integration Services - Unix DBA
-----------------------------------------------------|
email: mike.morgan_at_teldta.com | Phone: (608)845-4661 |
-----------------------------------------------------|
TDS Computing Services                               |
301 S. Westfield Road                                |
Madison, WI 53705  USA                               |
-----------------------------------------------------|