Re: Date presented as VARCHAR2 in forms6

[Quoted] Thanks, Mark and Daniel,

[Quoted] I totally agree with you, but unfortunately, it's not in my power to change [Quoted] it. The rationale for YYYYMMDD was to make it easily orderable by the other [Quoted] programs and validation routines, plus, in all the (15+) tables all the columns(hundreds) are made VARCHAR2. I have inherited this design :o((

Thanks for your help.

Sergey
[Quoted] MarkyG <markg_at_mymail.tm> wrote in message news: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 Sat Jul 21 2001 - 23:56:02 CEST