Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Date/Time format under Windoze95
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
![]() |
![]() |