Data processing: database and file management or data structures – Database design – Data structure types
Patent
1997-04-29
1999-05-11
Amsbury, Wayne
Data processing: database and file management or data structures
Database design
Data structure types
707 6, G06F17/30
Patent
active
059038950
ABSTRACT:
The present invention relates to a method for reformatting and using the existing 2 digit month field and the existing 2 digit day field in a conventional 8, 7 or 6 digit date format to accommodate new century information. The invention is particularly useful for dealing with 6 digits formats used in existing databases, for example, ASCII date formats of the form mm/dd/yy or dd/mm/yy or yy/mm/dd. The method of the present invention for encoding century information is based on numerically offsetting the range of 1 through 31 days in the day field and/or offsetting the range of 1 through 12 months in the month field. In ASCII, the constraint is the value of the largest number that can be represented in 2 digit ASCII form (i.e. 99). There can be 3 day field ranges, 1-31, 32-62, 63-93 within the range 1 through 99, and there can be 8 month field ranges, 1-12, 13-24, 25-36, 37-48, 49-60, 61-72, 73-84, 85-96. Each of the embodiments manipulate the digits in these fields to produce a century accumulated date. Thus, century may be inserted into the day field, the month field, or both the day and the month field. The century can also be extracted from the century accumulated date to produce a conventional date format.
REFERENCES:
patent: 5630118 (1997-05-01), Shaughnessy
patent: 5668989 (1997-09-01), Mao
patent: 5719826 (1998-02-01), Lips
patent: 5737735 (1998-04-01), Soeder
patent: 5758336 (1998-05-01), Brady
patent: 5758346 (1998-05-01), Baird
patent: 5761668 (1998-06-01), Adamchick
patent: 5765145 (1998-06-01), Marsiello
patent: 5794048 (1998-08-01), Brady
patent: 5797117 (1998-08-01), Gregovich
patent: 5806063 (1998-09-01), Dickens
patent: 5806067 (1998-09-01), Conner
patent: 5808889 (1998-09-01), Burgess
patent: 5809500 (1998-09-01), Nolan
The Year 2000 Computing Crises; a Millenium Data Conversion Plan, Jerome Murray, 1996.
Hoffman Milton R.
Slatin Ronald C.
LandOfFree
Method for reformation conventional three field date formats to does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method for reformation conventional three field date formats to , we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for reformation conventional three field date formats to will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-255646