RE: Date field's and their file space usage.

["Bob Cozzi" <cozzi@xxxxxxxxx>]

I think all systems should handle only up to Dec 31, 2099 so that we have a
Y2.1K problem and all of us get work during retirement.  Wait a minute...
I'll be long since dead by then... Let make it through 12/31/2019 before
we're needed again. <vbg> & <tic>

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Bruce Vining
Sent: Tuesday, January 11, 2005 3:44 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Date field's and their file space usage.





The MI architecture does provide for dates prior to January 1 0001.  The
database implementation of Date is to support a range of dates from January
1 0001 to December 31 9999 so as to match the support found on other
platforms (ISO standards for example), but the system certainly could
handle earlier (and later) dates if it had to :)




                                                                           
             Tony Carolla                                                  
             <carolla@xxxxxxxx                                             
             m>                                                         To 
             Sent by:                  RPG programming on the AS400 /      
             rpg400-l-bounces@         iSeries <rpg400-l@xxxxxxxxxxxx>     
             midrange.com                                               cc 
                                                                           
                                                                   Subject 
             01/11/2005 02:22          Re: Date field's and their file     
             PM                        space usage.                        
                                                                           
                                                                           
             Please respond to                                             
              RPG programming                                              
              on the AS400 /                                               
                  iSeries                                                  
                                                                           
                                                                           




I find date storage a fascinating topic!  This is interesting, because
it would seem that the earliest date available (even though only used
in a 'scholarly' sense), would be 0001-01-01, or January 1, 0001.  If
the Scaliger numbers go back to, basically January 1, -4713, then why
don't the allowed values for a Date field go back that far?


On Tue, 11 Jan 2005 13:01:29 -0600, Bruce Vining <bvining@xxxxxxxxxx>
wrote:
>
>
> > Date fields are all stored internally as a 4-byte integer. The value
> stored
> > is the number of days since January 1, 0001 or October 14, 1582, I'm
not
> > sure which it is.
>
> A minor point but date fields are actually stored using Scaliger numbers
> which have a base of January 1 4713 BCE.
>
> October 14 1582 is the base date for Lilian numbers which are used by the
> ILE CEE Date APIs.
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>


--
"Enter any 11-digit prime number to continue..."
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.



-- 
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.