Re: Date presented as VARCHAR2 in forms6
Date: 20 Jun 2001 01:48:50 -0700
Message-ID: <ab87195e.0106200048.54e1bea4_at_posting.google.com>
I agree with Daniel.
Storing dates as 'Date' is no problem, you can easily use a format
mask of YYYYMMDD for display purposes.
Mark
"Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message news:<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
>
> Change the field in the table to a date field. If you don't it will drive you
> crazy forever and you will have a miserable time doing date math.
>
> Daniel A. Morgan
Received on Wed Jun 20 2001 - 10:48:50 CEST