| TO_CHAR on a date field in Oracle 8.0.6 return zeros [message #371221] |
Tue, 19 September 2000 17:18 |
dpatel
Messages: 2
Registered: May 1999
Location: NJ
|
Junior Member |
|
|
We have 2 instances of Oracle with the same data except one instance is 8.0.6 and the other is 7.3.4.
On 8.0.6 the following sql returns zeros on a not null field:
select to_char(col1, 'YYYYMMDD') from tablea where col2 = 1000 ;
The output we get is '00000000'
If we just do select col1 from tablea where col2 = 1000;
Then an actual date appears.
On 7.3.4 for the same record we get the actual date with and without to_char.
The problem seems to be random (both 1999 and 2000 dates are coming out with zero's).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
