Re: [Q] How to change the default date format?

sajidhafeez_at_my-deja.com wrote:
>
> Hi all
>
> I am facing a problem while developing an application in Developer 2000
> and Oracle 8.
> That is, in the form I had bind a field with a database column, having
> date data type, now the problem is with Oracle?s default date format
> which is DD-MON-YY and I want to show it in DD-MM-YYYY format. If I
> change the mask of the control in forms it gives error and doesn?t
> display the date.

You can define the format in your initSID.ora file:

Here's what's in mine:

    # Use ANSI date format by default!
    nls_date_format = "YYYY-MM-DD"

If you want to make sure that Oracle puts this in the initSID.ora file for all of the databases you create, you'll want to define NLS_DATE_FORMAT in your ORACLE_HOME/rdbms/install/rdbms/initx.orc file.

Hope this helps. Received on Thu Jun 03 1999 - 14:48:21 CDT