× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. August 2002

Re: Allow *ZERO in a date (and timestamp) field? IBM?

Is the date field zero if certain other conditions are met?  Is there
such a thing as *NULL for a date field?

--Paul E Musselman
PaulMmn@ix.netcom.nospam.com



>Hi all (and IBMers),
>
>If the "date field restrictions" could be eased up to allow only valid dates
>(as it is now) OR zero in a date field, this would help us a lot.
>
>I am currently having to using a packed field to store dates on the db,
>primarily due to this restriction.  Oftentimes, I need to allow a zero in a
>date field, and current restrictions will not allow this.

>AS/Resources, Inc.
>William A.(Tony) Corbett
>IBM Certified Specialist - AS/400 Developer
>http://www.asresources.com
>corbett@asresources.com
>770-587-4812 (office)
>678-935-5006 (mobile)
>fax:  404-663-4737

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.