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

[rob@xxxxxxxxx]

I remember a funny story about a COBOL worker brought out of retirement to 
do Y2K work.  Got so swamped that he went into cryogenic suspension until 
the Y2K mess was over.  Something went wrong and they finally unfroze him 
around the year 9999.  And then it was to fix the Y10K issue and he knew 
COBOL.
There was more to it.  Something about the first person talking to him 
being the President - which was really a large screen image of Bill Gates.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





daparnin@xxxxxxxxxxxxxxxxxx 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
01/11/2005 04:53 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
rpg400-l@xxxxxxxxxxxx
cc

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










<snip>
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 :)
</snip>


Y10K ???


Dave Parnin
Nishikawa Standard Company
Topeka, IN  46571
daparnin@xxxxxxxxxxxxxxxxxx



  
                      Bruce Vining  
                      <bvining@xxxxxxxxx        To:       RPG programming 
on the AS400 / iSeries 
                      m> <rpg400-l@xxxxxxxxxxxx>@SMTP@CTB  
                      Sent by:                  cc:       (bcc: David A 
Parnin/Topeka/NISCO/SPCO) 
                      rpg400-l-bounces@m        Subject:  Re: Date field's 
and their file space usage. 
                      idrange.com  
  
  
                      01/11/2005 04:43  
                      PM  
                      Please respond to   
                      RPG programming on   
                      the AS400 /  
                      iSeries  
                      <rpg400-l@midrange   
                      .com>  
  
  







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.