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

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)

John Carr
+---
| 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
+---