ORACLE date values

[Blue]

G'day Aci

You need to establish a dummy date that won't interfere with the application
logic.  For example, 19010101.  Your program will have to test for this
value.

I don't think you can insert a zero date value using PL/SQL.  PowerHouse
will handle it fine by simply setting the date item to zero.

Regards,
Blue

> -----Original Message-----
> From: Aci Polajnar [mailto:Aci.Polajnar@rcc-irc.si]
> Sent: Tuesday, September 25, 2001 2:03 AM
> To: Blue; 'PowerHouse List'
> Subject: Re: ORACLE date values
>
>
> Hi!
>
> Thank you for response, but I still don't know how to enter dummy or zero
> value in to a date field. Can you give me PL/SQL example like INSERT INTO
> ..........??
>
> Thank you
>
>
>
>
> Blue wrote:
> >
> > 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.
> > >
> >
> > = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> > 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.
>
> --
>                   _\\///_
>                  (' 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______________________________________
>               (   )    (   )
>                \ (      ) /
>                 \_)    (_/
>