Q: Dates in Forms 3.0 / Oracle 7.2.2.4 / MMDDYYYY
Date: 1996/06/26
Message-ID: <4qrg88$h65_at_linet04.li.net>#1/1
Dilema:
In Forms 3, we want to have a date entry assume 19YY is only a 2 digit year
is entered. In Oracle 6.0.34, we forced input format to MM/DD/YYYY and wrote
a little routine that did this fine. However, in 7.2.2.3, it is turning
, for example, 06/06/95 into 06/06/0095 and 060695 into 06/06/0095.
Is there a routine, either built in, or custom written that will take care
of my problem?
Is there a solution???
I have tried writing something that turns a six or eight character entry
(assuming MMDDYY or MM/DD/YY) into this format, but MM/DD/YYY is the same
length as MMDDYYYY, so it fails.
--
=========================================================
http://www.li.net/~gsa/index.html
This is my signature file, not part of this mail message.
I point this out since some people are just plain stupid.
Received on Wed Jun 26 1996 - 00:00:00 CEST