Re: Problem with SQL*Plus Truncating Date Fields

[Quoted] 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 Tue Jan 04 2000 - 19:44:59 CET