|
At 06:47 PM 9/15/97 +0000, you wrote: >>> 2. Maintenance. Do we REALLY want to implement yet another >>> way to handle dates? We already have: Julian (YYDDD), >>> Gregorian (MMDDYY), Inverted Gregorian (YYMMDD), >>> Inverted Gregorian plus century digit (CYYMMDD - Synon), >>> Inverted full Gregorian (YYYYMMDD) All thanks to legacy >>> code. We have been focussing our maintenance efforts on >>> using the YYYYMMDD form to store dates in the database >>> because it is "natural;" Queries, EIS tools, Data warehouse >>> tools, data interchange are all easier. Any variety of RPG >>> (or any language) can read this form and understand it.. %%% Good way to fold it all together in a bundle >>SNIP<<.. > >And retrofit the old database and software? For free? This is so thorny >an issue. I'm in favour of a standard API, but the best I could do was >convince management to commit to was to retrofit if the occasion arises; >new dates in the database are to be YYYYMMDD, when we run across >other formats, we make a log so we can go back and fix them later, when >the clients decide to approve Y2K fees... > > > >Buck Calabro >Commsoft, Rensselaer, NY >========================= Buck How difficult is it for you to approve clients to approve Y2K money in the Rensselar area? Are most of your clients waiting it out or what? How far off is later? Standard date routines/interfaces/APIs whatever are helpful - some more than others Glenn ___________________________________________________ Glenn Ericson, Phoenix Consulting P O Box 701164 East Elmhurst NY 11370-3164 USA Ph. 718 898 9805 Fx. 718 446 1150 AS/400 & Year 2000- - Solutions Specialists ____________________________________________________ +--- | 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 mailing list archive is Copyright 1997-2025 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.