Re: Date *HIVAL was Urgent!!! NULLS & ZEROS

Isn't wanting invalid dates (i.e. special values) in a date type data field
a little like some programmers used to do on ye olde System 3 - leaving
blanks in a numeric field to indicate it was null? Anyone want to make the
argument that blanks in a numeric field is a "special value"? And I figure
it was a common occurrence or why are there all those options to ignore
decimal data error?

Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax

From: John P Carr <jpcarr@tredegar.com>
>
> On Wed, Dec 22, 1999 at 02:08:39PM -0600, Scott Klement wrote:
> > Sometimes the values of all zeros, or all nines are used as "special
> > values" which necessary in some applications -- but not possible with
> > the date data type.  I don't like using 0001-01-01 or 9999-12-31 as
> > special values for the simple reason that they ARE valid dates!!  I
> > don't WANT my special values to be valid dates!
>
>
> Yes,   But for the data type you used to use(numeric)   000000 and 999999
> Were also valid Numeric data in a Numeric field.
>
> So in the past your "Reserved Values"(000000 999999)  were valid
> for the data type(numeric)
>
> And now,   0001-01-01 & 9999-12-31  are valid for the data type(Date)


> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---


__________________________________________________
Do You Yahoo!?
Thousands of Stores.  Millions of Products.  All in one place.
Yahoo! Shopping: http://shopping.yahoo.com

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---