| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: sysdate display SQL 3.4 vs 8.0.5
I had a similar thing during y2k testing - below is a mail sent to me =
by a
colleague, it may help.
<snip>
I have spotted a small issue with y2k dates whereby server manager (and
certain versions of SQLPlus) will lose trailing digits. It's all to do =
with
the NLS_DATE_FORMAT set on the server in INIT.ORA or on the client's PC
registry being longer that the default display width of date columns in =
the
tools mentioned. Hence a date format of dd-mon-yyyy/value of =
01-jan-2000
will actually show up as 01-jan-20 if the display width of the tool is =
set
to 9 - you get the idea.
Note that this is only a display formatting problem and the date itself =
is
actually correctly stored in the database. It is easily fixed by =
setting an
appropriate DATEWIDTH parameter. However, if anybody has scripts that =
spool
out the date then these need to be checked especially if the spool =
files are
used for further processing (eg recording details of last backup sets =
etc).
HTH
-----Original Message-----
From: Ron Rogers [mailto:RROGERS_at_galottery.org]
Sent: 13 December 2000 21:22
To: Multiple recipients of list ORACLE-L
Subject: sysdate display SQL 3.4 vs 8.0.5
List,
We have a server running 7.3.4 and a client with SQL-PLUS ver 3.3.4 =
and
ver 8.0.5 in it. When we select a date field from the same table using =
the
different ver of SQL-PLUS the date field is 10 char on 3.3.3 and only 9 =
char
on 8.0.5. example: select sysdate from dual;
ver 3.3.4 displays 12-13-2000
ver 8.0.5 displays 12-13-200
I have checked the "show all" on both and I don't see a difference.
Both of the glogin.sql files are identical.
Does anyone have the answer... and 42 is not the on this time.
ROR m=AA=BF=AAm
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20
Author: Ron Rogers
INET: RROGERS_at_galottery.org
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Dec 15 2000 - 04:34:42 CST
 |
 |