Re: Time differences?

In article <314D9426.22FF_at_ibm.net>, tvlinge_at_ibm.net says...
>
>Hi,
>
>Ognian Nikolov wrote:
>>
>> Dear Oraclers
>>
>> 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.

Perhaps it was a type-o, but, the mask for minutes is 'MI' not 'MM'. The 03 in the character string produced by the TO_CHAR is the month of March. If it was just a type-o, then ignore this...it's a type-o I've made a number of times myself.

-- 
Bob Cunningham
bcunn_at_oanet.com
102426.2724_at_compuserve.com