Re: Date/Time format under Windoze95

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:13:28 CDT