ORACLE date values

[Aci Polajnar]

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______________________________________
              (   )    (   )
               \ (      ) /
                \_)    (_/