Re: sysdate display SQL 3.4 vs 8.0.5

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Thu, 14 Dec 2000 10:52:06 -0500
Message-Id: <10710.124575@fatcity.com>

Emine,
Thanks for the reply. The one client has both the versions of SQL-PLUS = loaded on it. The regional setting and the registry have been checked. I = might be missing something with the registry check but I think I got them = all.
ROR m=AA=BF=AAm

>>> emineates_at_postmaster.co.uk 12/14/00 03:17AM >>> hi,
I thought both of them running on NT and this problem seems to be related = with O/S configuration .
Did you check and compare the regional settings of these machines. Bye..
Emine

On Wed, 13 Dec 2000 13:21:34 -0800 "Ron Rogers" <RROGERS_at_galottery.org> = wrote:
> 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

> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
> --=20
> Author: Ron Rogers
> INET: RROGERS_at_galottery.org=20

>=20


> 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).
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author: Emine ATES
INET: emineates_at_postmaster.co.uk=20

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 Thu Dec 14 2000 - 09:52:06 CST