Re: DATE field questions - Forms 3.0/4.0
From: Jeremy L. Russell <jeremy_at_skills.demon.co.uk>
Date: Wed, 9 Nov 1994 09:26:54 +0000
Message-ID: <784373214snz_at_skills.demon.co.uk>
Date: Wed, 9 Nov 1994 09:26:54 +0000
Message-ID: <784373214snz_at_skills.demon.co.uk>
In article <KIVA.94Oct31123640_at_xmission.xmission.com>
kiva_at_xmission.xmission.com "KIVA" writes:
> We are looking for elegant ways to accomplish entry of dates into Oracle DATE
> fields in different formats: 3/31/94, 3.31.94, 31-3-94. We have created user
> exits in the past for allowing the user to enter the date in any of the above
> formats and translating that to the standard Oracle notation DD-MMM-YY. Does
> the Oracle have anything that would allow me to do the same without using an
> user exit?
>
> Risto Tolonen
> KIVA
> risto_at_kiva.com
>
>
Can you accept entry into a string field and convert using 'to_date' until
you get a good conversion?
-- Jeremy Russell - skills.demon.co.uk SkillAdvance Ltd - Phone +44 181 446 6481 -----------------------------------------Received on Wed Nov 09 1994 - 10:26:54 CET