Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Date/Time format under Windoze95

Date/Time format under Windoze95

From: Jim West <jwest_at_frii.com>
Date: Mon, 01 Jun 1998 20:59:59 GMT
Message-ID: <35732342.14187305@news.internetmci.com>


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 - 15:59:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US