Re: Date presented as VARCHAR2 in forms6
From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sat, 21 Jul 2001 21:55:28 GMT
Message-ID: <3B303ECC.74081AB2_at_exesolutions.com>
Date: Sat, 21 Jul 2001 21:55:28 GMT
Message-ID: <3B303ECC.74081AB2_at_exesolutions.com>
SeredinaMy wrote:
> Hi guys,
>
> I have a table where date stored in YYYYMMDD as VARCHAR2. This goes to the
> form into VARCHAR2 field. Users would like to see it in DD-MON-YYYY as a
> date, update it if needed and save back as ...VARCHAR2 again in YYYYMMDD.
>
> Please, tell me, what is the easiest way to achieve this?
>
> Appreciate your time and help.
>
> Sergey
[Quoted] [Quoted] Change the field in the table to a date field. If you don't it will drive you [Quoted] [Quoted] crazy forever and you will have a miserable time doing date math.
Daniel A. Morgan Received on Sat Jul 21 2001 - 23:55:28 CEST