Re: Problem with SQL*Plus Truncating Date Fields

Here is the latest. There is a bug which exists on (at least) versions 8.0.4 and 8.0.5 of SQL*PLUS for SUN. This bug has been fixed in versions 8.1.5 and higher and was backported to 8.0.4 (at the request of a customer) but has never been backported to 8.0.5.

The bug number is 663806.

jk

Jeffrey H. Knodel <knodel_at_knodel.net> wrote in message news:38724050$0$1379_at_news.voyager.net...
> Just FYI: Oracle's Second Line support came back.
> This is a bug in the Solaris 8.0.5 SQL*Plus, and
> they're sending us the patch...
>
> jk
>
>
> Jeffrey H. Knodel <knodel_at_knodel.net> wrote in message
> news:387227d5$0$1808_at_news.infinet.com...
> > Sorry if this is a stupid question, but I'm a UNIX admin, not a DBA.
> >
> > We're moving an application platform from AIX to Solaris which
> > connects to an Oracle 7 database running under OS390.
> >
> > Under SQL*Plus, when we do a query (such as select SYSDATE from dual;)
> > we get "01/04/200" under Solaris and "01/04/2000" under AIX.
> > (It truncates at 9 characters, rather than 10.) This is true for all
date
> > fields returned under SQL*Plus.
> >
> > "Format column sysdate a10" widens the result header to 10 characters,
> > but leaves the data truncated at 9.
> >
> > "Alter session NLS_DATE_FORMAT='YYYY/MM/DD'" makes is so that
> > the second day of the date field is truncated, rather than the year (ala
> > "2000/01/0")
> >
> > However, performing a "tochar" format of the date returned works
properly.
> >
> > I presume that there is a general system file someplace that this is
> > set it that we've failed to move from AIX to Solaris, but I have not
> > managed to find it yet, and this has stumped Oracle's frontline support
> > people. (I'm still waiting to make it to the techies...)
> >
> > Any help would be appreciated.
> >
> > jk
> >
> > --
> > +-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
> > | Jeffrey H. Knodel knodel_at_knodel.net http://www.knodel.net/~knodel |
> > | "This isn't hell, but I can see it from here." |
> > +-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
> >
> >
> >
> >
>
>
Received on Wed Jan 05 2000 - 19:44:02 CET