Re: Storing dates - revisted...

Love it <BG> !

Thanks Kathleen !

"LUCKILY" I'm on a new job and we are moving from a Unix machine to the AS/400
(YEAH !!!!!!) so the 3rd party stuff is all Y2K ready.

I just trying to get myself up to speed from the MULT 10000.01 and 100.0001 days
:-)

But thank you very much for the pointers ! I agree that at this point, anyone
just getting rolling (YIKES) should do the quick and dirty and come back to it
latter, as LONG AS LATTER COMES !!!

Chuck

Kathleen Kostuck wrote:

> Hi Chuck,
>
> First of all I want to disclose that I do not have any Y2K projects under
> my belt, as I have been moderately successful at avoiding them, and also
> any design work I've done in the past 10 years has been Y2K compliant. But,
> here goes with some advice, and please forgive any wrong assumptions I may
> be making... :^)
>
> Since this is September of 1998, forget about new development until you get
> your Y2K project done.  I don't know how large your project is or what kind
> of resources you have, but since the project is more likely to grow than to
> shrink, and resources vice versa, you need to focus.
>
> If your package uses 2,0 centuries, the easiest method would be to add 2,0
> century fields to the end of your other record formats.  Do not attempt to
> change your existing date fields, either to lengthen them or to change to
> the date data type. If you change them, you will have just sentenced
> yourself to the 'Big Bang' method of date remediation. You will not be able
> to break the project into manageable chunks, you will not be able to
> prioritize programs or systems, you will be forced to replace every
> (non-pkg) production object on your system all in one shot.
>
> I'd like to tell you to change everything to the date data type, but I
> won't be there to help you when your order entry or forecasting breaks
> down, and you can't fix it because commission isn't done yet.
>
> IMHO forget about what you'd ideally like to do and just get it done.
>
> Now I'm going to put on my flame retardant suit and duck and run...
>
> Kathleen Kostuck
> ___________________
> pager (414) 402-0820       fax (414) 495-4986
> kkostuck@execpc.com
> AS400 Solutions
> Secretary - Wisconsin Midrange Computer Professionals Association
> ___________________
>
> > From: Chuck Lewis <CLEWIS@IQUEST.NET>
> > To: MIDRANGE-L@midrange.com
> > Subject: Re: Storing dates - revisted...
> > Date: Wednesday, September 23, 1998 8:07 PM
> >
> > Not to quibble, but how is using what the package uses, and for new
> fields using
> > the real date, consistent :-) ?
> >
> > I understand what Rob saysm I think. Stuck with a vendors choice, when
> it's your
> > choice use what REALLY makes sense, complete date...
> >
> > Kathleen Kostuck wrote:
> >
> > > That's good advice.  Whatever you do, be consistent.
> > > kk
> > >
> > > ----------
> > > > From: Rob Berendt <rob@dekko.com>
> > > > To: MIDRANGE-L@midrange.com
> > > > Subject: Re: Storing dates - revisted...
> > > > Date: Wednesday, September 23, 1998 6:18 PM
> > > >
> > > > We use what our packages use.  For new fields we use the real date
> > > fields.
> > > >
> > > >
> > > >
> > > >
> > > > CLEWIS@IQUEST.NET on 09/21/98 01:01:25 PM
> > > > Please respond to MIDRANGE-L@midrange.com@Internet
> > > > To:   MIDRANGE-L@midrange.com@Internet
> > > > cc:
> > > > Subject:      Storing dates - revisted...
> > > >
> > > > More questions on date storage !
> > > >
> > > > You can change all of your old date storage in files from YY/MM/DD to
> > > > YYYY/MM/DD. Is that what folks are doing ?
> > > >
> > > > We are on V4R1 and IBM is storing the QYEAR as YY and then there is
> > > > QCENTURY as 0=1920-1999 and 1=2000=2053.
> > > >
> > > > It seems to me that YYYY/MM/DD is the better way to go (more
> > > > straightforward) as century really is "clumsy" )have to remember
> where 0
> > > > and 1 start and stop)... ??????/
> > > >
> > > > Or does it matter ?
> > > >
> > > > What's everyone doing ?
> > > >
> > > > We have a software package that is storing Century as 2 digits and
> has
> > > > 19 in it !!!
> > > >
> > > > Thanks !
> > > >
> > > > Chuck
> > > >
> > > > +---
> > > > | This is the Midrange System Mailing List!
> > > > | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> > > > | To subscribe to this list send email to
> MIDRANGE-L-SUB@midrange.com.
> > > > | To unsubscribe from this list send email to
> > > MIDRANGE-L-UNSUB@midrange.com.
> > > > | Questions should be directed to the list owner/operator:
> > > david@midrange.com
> > > > +---
> > > >
> > > >
> > > > +---
> > > > | This is the Midrange System Mailing List!
> > > > | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> > > > | To subscribe to this list send email to
> MIDRANGE-L-SUB@midrange.com.
> > > > | To unsubscribe from this list send email to
> > > MIDRANGE-L-UNSUB@midrange.com.
> > > > | Questions should be directed to the list owner/operator:
> > > david@midrange.com
> > > > +---
> > > +---
> > > | This is the Midrange System Mailing List!
> > > | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> > > | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> > > | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> > > | Questions should be directed to the list owner/operator:
> david@midrange.com
> > > +---
> >
> > +---
> > | This is the Midrange System Mailing List!
> > | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> > | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> > | Questions should be directed to the list owner/operator:
> david@midrange.com
> > +---
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---