Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> sysdate display SQL 3.4 vs 8.0.5
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
![]() |
![]() |