I think the problem is in Oracle with the default date mask. It is probably
'DD-MMM-CCYY'. It should probably be something like 'DD-MMM-RR'. You'll
have to read the Oracle manual and figure it out.
What version of PowerBuilder are you running? I believe versions before
5.0.04 are not Y2K compliant. You should check with Sybase.
Curtis Hanner
Custom Systems LLC
----- Original Message -----
From: Martin Phillips <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 24, 1999 2:45 PM
Subject: PFCSIG PFC. Dates from Datawindows
> Hello...
> A perplexing problem:
>
> I have a datawindow that inserts dates (dd/mm/yyyy or dd/mm/yy) or inserts
> dates from a winnt popup calander. Either way the date is entered it is
> then saved to an oracle 8.05 database. When I insert a 1999 date , e.g.
> 12/01/99 or 12/01/1999 the appearance is fine, even after it is saved.
But
> if I exit the window and come back in, then do a retrieve I get 12/01/2099
a
> century later. It is being stored into the Oracle database as the year
> 2099.
>
> I have tried messing with the windows regional settings on both the client
> and the server, this makes no difference at all.
>
> Any suggestions how the pfc update function can be corrected to store the
> correct year?
>
> Thanks in advance.
>
> Martin
>
>
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS,
ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help
pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
>
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
