Re: Dates in SQL?

Keyoor wrote:
>
> Hi,
>
> I don't know how can the DBA change the default date format ?
> What is the exact method ? Can you help me, please ?
> Does this Default Date format apply to ALL date conversion from Char->Date
> and vice versa as well !

You can set the default date format for your current session:

ie: ALTER SESSION SET NLS_DATE_FORMAT = '<format>';

The DBA can set the default date format for the database instance by setting the nls_date_format parameter in the init.ora file and restarting the instance.

ie: nls_date_format = <format>

-- 
Mike Biggin
DENR, South Australian Government
E-mail: mbiggin_at_denr.sa.gov.au
Phone: +61 8 8204 9217; Fax: +61 8 8204 9017

Unless explicitly attributed, the opinions expressed are personal
and not those of DENR or the South Australian Government.