 |
|
|
|
|
|
 Title: |
US5806063:
Date formatting and sorting for dates spanning the turn of the century
[ Derwent Title ]
|
| Country: |
US United States of America
|
| |
| Inventor: |
Dickens, Bruce; Irvine, CA
|
| Assignee: |
McDonnell Douglas Corporation, Long Beach, CA
other patents from MCDONNELL DOUGLAS CORP. (361390) (approx. 1,653)
News, Profiles, Stocks and More about this company
|
| Published / Filed: |
1998-09-08
/ 1996-10-03
|
| Application Number: |
US1996000725574
|
| IPC Code: |
Advanced:
G06F 9/44;
Core:
more...
IPC-7:
G06F 17/30;
|
| ECLA Code: |
G06F9/44G4M2;
|
| U.S. Class: |
Current:
707/006;
707/007;
707/102;
707/200;
Original:
707/006;
707/102;
707/007;
707/200;
|
| Field of Search: |
707/006,102,7,200
|
| Priority Number: |
| 1996-10-03 |
US1996000725574 |
|
| Abstract: |
Dates stored in symbolic form in a database are reformatted to permit easy manipulation and sorting of date-related information. Each date in M1 M2, D1 D2, and Y1 Y2 format is converted to C1 C2, Y1 Y2, M1 M2, and D1 D2 format. To accomplish the conversion, a 10-decade window starting on YA YB is defined that encompasses all dates in the database. The value of C1 C2 is determined by the relative values of Y1 Y2 and YA YB. The reformatted date information is particularly useful when the reformatting is in C1 C2 Y1 Y2 M1 M2 D1 D2 format, because sorting by date is accomplished using a pure numerical-value sort.
|
| Attorney, Agent or Firm: |
Bell Seltzer Intellectual Property Group of Alston & Bird LLP ;
|
| Primary / Asst. Examiners: |
Amsbury, Wayne;
|
| Maintenance Status: |
CC Certificate of Correction issued
|
| INPADOC Legal Status: |
Show legal status actions
|
| Family: |
None
|
First Claim:
Show all 15 claims |
What is claimed is:
1. A method of processing symbolic representations of dates stored in a database, comprising the steps of
- providing a database with symbolic representations of dates stored therein according to a format wherein M1 M2 is the numerical month designator, D1 D2 is the numerical day designator, and Y1 Y2 is the numerical year designator, all of the symbolic representations of dates falling within a 10-decade period of time;
- selecting a 10-decade window with a YA YB value for the first decade of the window, YA YB being no later than the earliest Y1 Y2 year designator in the database;
- determining a century designator C1 C2 for each symbolic representation of a date in the database, C1 C2 having a first value if Y1 Y2 is less than YA YB and having a second value if Y1 Y2 is equal to or greater than YA YB ; and
- reformatting the symbolic representation of the date with the values C1 C2, Y1 Y2, M1 M2 , and D1 D2 to facilitate further processing of the dates.
|
| Background / Summary: |
Show background / summary
|
| Drawing Descriptions: |
Show drawing descriptions
|
| Description: |
Show description
|
| Forward References: |
Show 18 U.S. patent(s) that reference this one
|
|
