Re: date insertion error

From: Jan Korecki <Jan.Korecki_at_contactor.se>
Date: Tue, 25 Nov 2003 15:17:55 +0100
Message-ID: <3fc364ca$0$97834$57c3e1d3@news3.bahnhof.se>

mcstock wrote:
> yousaf,
>
> regarding the date error -- always use explicit date conversion (with the
> TO_DATE() function) when using string literals to populate oracle date
> columns. it is very possible that the session setting NLS_DATE_FORMAT will
> be different in different environments -- either because the DBA sets it
> differently in different databases or because some other code using the same
> session issues an ALTER SESSION statement to change it (this is especially a
> potential problem in web-based apps where sessions are re-used)
>
> regarding the hanging -- not enough details to provide any assistance --
> suggest you re-post with more details and a different subject
>
> -- mcs

yep. You and Daniel Morgan are correct.

One should always do explicit type conversions.

I stand corrected.

Janne! Received on Tue Nov 25 2003 - 08:17:55 CST