Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Data window edit masks - [PB 4.0/Oracle]

Data window edit masks - [PB 4.0/Oracle]

From: AV <Anthony_Varriano_at_pcmailgw.ml.com>
Date: 1997/04/09
Message-ID: <334C35C4.290E@pcmailgw.ml.com>#1/1 







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).



Any ideas?
Received on Wed Apr 09 1997 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US