Re: Data window edit masks - [PB 4.0/Oracle]

From: Bruce Armstrong <NOCANSPAM_brucearm_at_ix.netcom.com>
Date: 1997/04/11
Message-ID: <334d0bea.1032356@nntp.ix.netcom.com>#1/1

AV <Anthony_Varriano_at_pcmailgw.ml.com> wrote:

>I am using an edit mask (dd/mm/yyyy) in a PB 4.0 datawindow to save a
>date to an Oracle database. The default Oracle date format is
>'DD-MMM-YY' (i.e. 01-JAN-96). When I save a date less than 1900, the
>year is recorded by Oracle as one hundred years less than the actual
>date (i.e. 3/1/1898 would be recorded as 3/1/1798).

It doesn't matter what format you display the date in so much. The problem is a bug that I believe is fixed in the latest set of patches.

Bruce Armstrong				| Source Consulting
mailto:brucearm_at_ix.netcom.com		| mailto:jobs_at_sourcela.com
http://www.netcom.com/~brucearm/	| http://www.sourcela.com

Preach the gospel at all times.If necessary, use words.	[Francis of Assisi]

Received on Fri Apr 11 1997 - 00:00:00 CDT