Re: nls date values
- From: Janus Christensen <januschr@xxxxxxxxx>
- To: jdunn@xxxxxxxxx
- Date: Mon, 18 Oct 2004 10:32:39 +0200
On Mon, 18 Oct 2004 09:04:15 +0100, John Dunn <jdunn@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
