Problem with SQL*Plus Truncating Date Fields
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