Re: Date/Time format under Windoze95

On Mon, 01 Jun 1998 21:13:28 GMT, jwest_at_frii.com (Jim West) wrote:

Ok, One more time. You know, I just that talking about this would certainly help! :)

On a whim I tried the following:

Ran REGEDIT.

Inserted a new string value under the ORACLE key with the name NLS_DATE_FORMAT and the value of MM/DD/YYYY HH24:MI:SS and fired up SQL*Plus again and VIOLA! exactly what I was looking for.

New Key:

        HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/NLS_DATE_FORMAT Thanx for listening!

>On Mon, 01 Jun 1998 20:59:59 GMT, jwest_at_frii.com (Jim West) wrote:
>
>Ok, I've got the following to work:
>
> alter session set NLS_DATE_FORMAT = 'MM/DD/YYYY HH24:MI:SS';
>
>How do I make this "happen" everytime I fire up SQL*Plus on Windoze95?
>
>Thanx.
>
>>Howdy all,
>>
>> OK, I'm not able to find the info I'm looking for, so I'm here to
>>plead to you Oracle gods for help.
>>
>> Here's da scoop:
>>
>> Got Oracle 8.0.4 running on Sun E5000/Solaris 2.6.
>>
>> I run SQL*Plus from my UNIX shell.
>>
>> I enter:
>>
>> select sysdate from dual;
>>
>>I get:
>>
>> SYSDATE
>> ---------------------------------
>> 06/01/1998 14:56:55
>>
>>
>>Which is exactly what I desire.
>>
>>
>>Now, I execute SQL*Plus from Windoze95.
>>
>>I enter:
>>
>> select sysdate from dual;
>>
>>I get:
>>
>> SYSDATE
>> ------------------
>> 01-JUN-98
>>
>>This is NOT what I desire.
>>
>>How do I change the date/time format under the Windoze95 SQL*Plus to
>>match what I receive from the Solaris version of SQL*Plus.
>>
>>Note: Same username used on both.
>>
>>Any and all help is appreciated!
>>
>>Thanx!
Received on Mon Jun 01 1998 - 16:26:24 CDT