Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> sysdate display SQL 3.4 vs 8.0.5

sysdate display SQL 3.4 vs 8.0.5

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Wed, 13 Dec 2000 16:18:25 -0500
Message-Id: <10709.124497@fatcity.com>


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 Received on Wed Dec 13 2000 - 15:18:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US