Re: ORACLE-Internal-Date-Format

Dates are stored as number types. Look under the SQL reference for more information. If you really want to get into the guts of it, create a single-row table with a date column, insert a date into it and go dump the thing out and play with it for a while.

Roger

Roger Snowden
Sr. Systems Engineering Specialist
Oracle Corporation
rsnowden_at_NOTus.oracle.com <-- to reply, remove the obvious

Reinhard Wahl wrote:
>
> Does anyone know how ORACLE stores Date-entries internal?
> Where can I find it in the documentation?
>
> Any idea?
>
> Thanks in advance
>
> Reinhard
>
> ----------------------------------------------------
> E-Mail_at_work: mailto:wahl_at_zv.fhg.de
> E-Mail_at_home: mailto:ReinhardWahl_at_online.de
> ----------------------------------------------------
> Website http://www.online.de/homepages/ReinhardWahl
> ----------------------------------------------------
> Hiermit widerspreche ich der Nutzung oder
> Uebermittlung meiner Daten fuer Werbezwecke
> oder fuer die Markt- oder Meinungsforschung
> gemaess Par. 28 Abs. 3 Bundesdatenschutzgesetz.
> ----------------------------------------------------
> Please do not use my E-Mail address for advertising!
> ----------------------------------------------------
Received on Tue Dec 22 1998 - 00:00:00 CST