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

[RPower@xxxxxxxxxx]

Well,
Anyone using the 'sliding window' technique will have to do it all again 
in 2040 if they don't convert over.  Boy did I get tired of writing:
If      Year > 40
Eval    Century_Bit = '1'
Else
Eval    Century_Bit = '0'
EndIf

Over and over and over.  Sigh.

Ron Power
Programmer
Information Services
City Of St. John's, NL
P.O. Box 908
St. John's, NL
A1C 5M2
Tel: 709-576-8132
Email: rpower@xxxxxxxxxx
Website: http://www.stjohns.ca/
___________________________________________________________________________
Success is going from failure to failure without a loss of enthusiasm. - 
Sir Winston Churchill




"Bob Cozzi" <cozzi@xxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
11/01/2005 06:21 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx>
cc

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






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.




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