RE: Reading DUMP of DATE field

  • From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 25 Feb 2004 15:44:03 -0600

You'd *think* that, wouldn't you?  My problem is the OCI bug which allows
this:

        Typ=12 Len=7: 100,100,0,0,1,1,1

Perhaps we can make some workarounds...  <sigh>

Thanks Daniel and Igor!

Rich

Rich Jesse                        System/Database Administrator
rich.jesse@xxxxxxxxxxxxxxxxx      QuadTech, Sussex, WI USA

> -----Original Message-----
> From: Daniel Fink [mailto:Daniel.Fink@xxxxxxx]
> Sent: Wednesday, February 25, 2004 3:32 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Re: Reading DUMP of DATE field
> 

[snip]

> The reason for the excess is that the value cannot be stored 
> as a 0, even
> though 0 is allowable in some fields. Obviously we don't have 
> a month 0 nor day
> 0.
> 
> Daniel
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: