ORACLE date values

[Blue]

If you MUST have a value in the column then use a dummy, or even a zero
value otherwise the result will be unpredictable.

One caution: Oracle 7.3 WILL accept a zero in a date column BUT only
PowerHouse will know what to do with it.  I.e. PL/SQL and other non-Cognos
tools can't deal with a zero date value.

Blue

> -----Original Message-----
> From: powerh-l-admin@cube.swau.edu
> [mailto:powerh-l-admin@cube.swau.edu]On Behalf Of Aci Polajnar
> Sent: Monday, September 24, 2001 2:28 AM
> To: 'PowerHouse List'
> Subject: ORACLE date values
>
>
> Hi there!
>
> Does anybody know, what is going on, when I just press enter on a date
> field while entering dates to an ORACLE 7.3 table. If I recall this
> row, my date field is shown as blanck on a QUICK screen and
> '00000000 1200' if
> I select this date from the table with
>
> select to_char(mydate,'ddmmyyyy hhmiss') from mytable
>
> Table, I am working on looks like this:
>
> CREATE TABLE XOCTEST

>   ID      CHAR (10)     NOT NULL,
>   DATOTV  DATE          NOT NULL ) ;
>
> My problem is, that I should write an PL/SQL procedure to insert
> such a dates
> to the table which will not be seen on an QUICK screen.
> Also I can't remove NOT NULL option from the table because it is an index
> field.
>
> Thank you
>
>
>
> --
>                   _\\///_
>                  (' o-o ')
> _______________ooOo_( )_oOoo_____________________________________
>
> Aci Polajnar                  Tel   : +386(0)3 4274174
> IS Consultant                 Fax   : +386(0)3 4274198
> Razvojni Center Celje         e-mail: acip@rcc-irc.si
> 3000 Celje, Slovenia          URL   : http://www.rcc-irc.si
> _______________oooO____Oooo______________________________________
>               (   )    (   )
>                \ (      ) /
>                 \_)    (_/
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe" in message body to
> powerh-l-request@lists.swau.edu
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
>