× 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.



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.





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
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.