× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: Year 2K - how to shake down your system
  • From: DAsmussen@xxxxxxx
  • Date: Sat, 16 Aug 1997 18:36:35 -0400 (EDT)

Wayne,

In a message dated 97-08-15 20:57:10 EDT, you write:

> >>DAsmussen@aol.com wrote:
>  >>> 
>  >Would you believe, I know a company !-) that has separate fields for
year,
>  >month & day?

(Actually, I didn't write that -- it was the original poster)

>  Am I being dense? That sounds like a good place to be! 
>  The database can be changed to include century fields without changing any
>  of the existing code.
>  All of the year fields have names that can be easily scanned for.
>  I'll bet that much of the date formatting is done in data structures --
>  again easily scanned and centralized in a copy member if you're feeling
>  ambitious.

Well, the software overhead is horrendous, and queries are MUCH larger than
they need to be.  Not to mention the fact that third-party query tools or
EIS's will not perform at optimum under these circumstances.  How do you
figure that the database can be changed without code changes, given sort
criteria and all?

>  It's the databases(?) that have dates stored in 47 different formats that
>  leave me feeling chapped.

And why would month, day, year storage have any impact on THIS?  Older
applications are still bound to have things stored in both MDY and YMD
format, and sorts will still have to be modified to include the century...

JMHO,

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
E-Mail:  DAsmussen@AOL.COM

"In America, anyone can become President.  That's one of the risks you take."
-- Adlai Stephenson
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.