Thanks, Jason but we have been all through that end of it with no success.
Success did come however from the following text:
"How Dates are sent to Oracle"
"DiableBind off"
"Powerbuilder sends dates in the internal Oracle format. This format always
includes a four digit year so whatever date is entered into PowerBuilder is
the date Oracle will use. This is true for PB 5.04 and above."
Se we set " DBParm= 'DiableBind=off' " and presto we have no more date
problems.
Thanks for your assistance nonetheless.
Martin
-----Original Message-----
From: Jason Vogel [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 26, 1999 7:59 AM
To: Martin Phillips
Cc: [EMAIL PROTECTED]
Subject: RE: PFCSIG PFC. Dates from Datawindows
Ask your Oracle DBA about the nls_date_format value in the init.ora startup
on the database. S/he should be able to help you. You may be surprised to
here about some other valid formats, like mm/dd/rrrr.
Jason
-----Original Message-----
From: Martin Phillips [ mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> ]
Sent: Wednesday, November 24, 1999 4:46 PM
To: '[EMAIL PROTECTED]'
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]
