Re: Date Format Question
From: Grue <grue_at_hotmail.com>
Date: 1998/01/14
Message-ID: <34bce0fa.7099811_at_128.158.254.10>#1/1
Date: 1998/01/14
Message-ID: <34bce0fa.7099811_at_128.158.254.10>#1/1
On Mon, 12 Jan 1998 11:33:58 -0500, zhang <zhang_at_visi.net> wrote:
>
> How can I change default conversion mask in To_date() so FORMS can
> implicitly convert other date formats except "DD-MON-YY"? Any
> Suggests are greatly appreciated.
>
You can change the default date format for an instance using the
NLS_DATE_FORMAT parameter. In your parameter file (INIT.ORA or some
variation), set this parameter as follows:
NLS_DATE_FORMAT = "MM/DD/YYYY" Of course, substitute whatever format you want to be the default.
Grue Received on Wed Jan 14 1998 - 00:00:00 CET