Oracle 8 internal date storage format ?

From: <danmorales_at_my-dejanews.com>
Date: Mon, 22 Jun 1998 20:03:51 GMT
Message-ID: <6mmdb7$3c9$1@nnrp1.dejanews.com>

Does anyone know how Oracle stores dates internally in Oracle 8.x ?

In Oracle 7.x, it was seven bytes:
  byte1 century (excess 100)
  byte2 year (excess 100)
  byte3 month
  byte4 day
  byte5 hour (excess 1)
  byte6 minute (excess 1)
  byte7 second (excess 1)

In Oracle 8.x, if you select oracle data into a LOB (OCI) and walk through the data, the above layout no longer holds true in Oracle 8.0.3 and 8.0.4.

Can anyone help?

Please email me directly at dmorales_at_prismsolutions.com

Thanks,
Dan Morales
Prism Solutions, Inc.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Jun 22 1998 - 15:03:51 CDT