ORACLE date values

[Jones Allen (Van)]

We have the same situation here.  The problem is that zero is not a valid
date.  Use a select statement like:

select to_char(mydate,'YYYYMMDD') mydate from mytable where 0 =
to_number(to_char(mydate,'YYYYMMDD'));

This selcts zero dates and the result is:

MYDATE
-----------
00000000
00000000
00000000
00000000
00000000

-----Original Message-----
From: Aci Polajnar [mailto:Aci.Polajnar@rcc-irc.si]
Sent: Monday, September 24, 2001 12: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.