Data processing: database and file management or data structures – Database design – Data structure types
Patent
1996-10-03
1998-09-08
Amsbury, Wayne
Data processing: database and file management or data structures
Database design
Data structure types
707102, 707 7, 707200, G06F 1730
Patent
active
058060634
ABSTRACT:
Dates stored in symbolic form in a database are reformatted to permit easy manipulation and sorting of date-related information. Each date in M.sub.1 M.sub.2, D.sub.1 D.sub.2, and Y.sub.1 Y.sub.2 format is converted to C.sub.1 C.sub.2, Y.sub.1 Y.sub.2, M.sub.1 M.sub.2, and D.sub.1 D.sub.2 format. To accomplish the conversion, a 10-decade window starting on Y.sub.A Y.sub.B is defined that encompasses all dates in the database. The value of C.sub.1 C.sub.2 is determined by the relative values of Y.sub.1 Y.sub.2 and Y.sub.A Y.sub.B. The reformatted date information is particularly useful when the reformatting is in C.sub.1 C.sub.2 Y.sub.1 Y.sub.2 M.sub.1 M.sub.2 D.sub.1 D.sub.2 format, because sorting by date is accomplished using a pure numerical-value sort.
REFERENCES:
patent: 4573127 (1986-02-01), Korff
patent: 5630118 (1997-05-01), Shaughnessy
patent: 5644762 (1997-07-01), Soeder
patent: 5668989 (1997-09-01), Mao
The Year 2000 and 2-Digit Dates: A Guide for Planning and Implementation, Third Edition, May, 1996.
IBM: The Year 2000 and 2-Digit Dates: A Guide for Planning and Implementation; First Edition, Oct. 1995.
Amsbury Wayne
McDonnell Douglas Corporation
LandOfFree
Date formatting and sorting for dates spanning the turn of the c does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Date formatting and sorting for dates spanning the turn of the c, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Date formatting and sorting for dates spanning the turn of the c will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-1296308