Re: Date Masking

Generally -- Oracle is actually always storing a date element with date and time included.

The NLS_DATE_FORMAT is the default date format.

One can alway override this. In SQLPlus ... to_char(date_field, 'MM/DD/RRRR')

                        in forms and in reportWriter, one can use the format

Mike Krolewski

Ken Halsted wrote:

> I'm using Designer 2000 to generate a form. My NLS_DATE_FORMAT in the
> registry is MMDDRRRR so that the user's don't have to enter the slashes when
> entering a date.
>
> Is there a way to have the form put the slashes in (just for the sake of
> looking better) after the date is keyed. How do developers normally handle
> this? Does everyone always just force the users to enter the slashes on
> every date field?
>
> I'm new so I'd appreciate some help on this one.
>
> Ken Halsted
> kenman_at_mail.snider.net
Received on Fri May 08 1998 - 09:03:26 CEST