Re: nls date values

From: Janus Christensen <januschr_at_gmail.com>
Date: Mon, 18 Oct 2004 10:32:39 +0200
Message-ID: <cd40318904101801327298f699@mail.gmail.com>

On Mon, 18 Oct 2004 09:04:15 +0100, John Dunn <jdunn_at_sefas.com> wrote:
> What affect does setting nls_date_language and nls_date_format have?

NLS_DATE_LANGUAGE defines the default language for dates. This has importance when using 'DD-MON-YYYY' (for example) as a format mask. When set to Danish the 1st of May 2004, would be 01-MAJ-2004 -- "Maj" is the Danish name for "May"; when set to English it would be 01-MAY-2004. This means that if NLS_DATE_LANGUAGE is set to Danish and you try to assign a date value from a string (without setting the format string explicitly) with the value '01-MAY-2004, you would get an errror.

NLS_DATE_FORMAT defines the default format mask of dates when using the to_char and to_date functions.

-- 
Janus Christensen
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 18 2004 - 03:28:15 CDT