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 -> Does "0" exist for DATE?

Does "0" exist for DATE?

From: Casey Claiborne <mscasey_at_io.com>
Date: Fri, 7 Jan 2000 06:35:20 -0600
Message-ID: <Pine.LNX.4.10.10001070630500.17388-100000@fnord.io.com> 






Hello,



Is there a way to initialize DATE with a default? For example, an 
INTEGER type can be set to 0, so can a FLOAT. 



For example, suppose I have a field for a Customer called 
DateOfMarriage. If the customer is not married, this field does not
apply. What can I set it to in the database? If I use NULL, then
I will have to worry about ISNULL or ISNOTNULL situations.



Any help on this issue would be *greatly* appreciated :)




TIA


Casey


Received on Fri Jan 07 2000 - 06:35:20 CST












Original text of this message













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