Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORACLE-Internal-Date-Format

Re: ORACLE-Internal-Date-Format

From: nguyen dao <ndao_at_hawaii.edu>
Date: 1998/12/21
Message-ID: <367f3180.0@bonaparte.pixi.com>#1/1

Does anyone give me some help on Date format: I got the error message: FRM-50021: Date Must be entered in a format like dd/mm/yy. Thanks

Roger Snowden wrote in message <367F00C6.6B8E5136_at_NOT.com>...
>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 Mon Dec 21 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US