Problem with SQL*Plus Truncating Date Fields

From: Jeffrey H. Knodel <knodel_at_knodel.net>
Date: Tue, 4 Jan 2000 12:00:43 -0500
Message-ID: <387227d5$0$1808_at_news.infinet.com>



[Quoted] 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 [Quoted] 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.

[Quoted] 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 - 18:00:43 CET

Original text of this message