Re: Date comparison question.

From: JRStern <JRStern_at_primalsys.com>
Date: Fri, 22 May 1998 21:11:05 GMT
Message-ID: <3565e9bc.14107775@news1.occa.home.net>

On Fri, 22 May 1998 06:17:16 GMT, andreas.prusch_at_sintec.de wrote:
>The contents of the type DATE is more then Month/Day and Year. It also
>contains hour, minute and second. Your default date format forces the
>database to convert your date without hour, minute and second, so it works.
>In general your program should use explizit format models like
>to_date('12-3-98', 'MM-DD-YY') so that you're independent of the
>default date format which can change an all your programs won't work any
>longer.

Newbie question: how do you get Oracle to display the current setting of the nls_date_format? alter session set changes it, but I want to see what the default was (I think I know, but, ...). On NT, fwiw.

Joshua Stern
JRStern_at_primalsys.com Received on Fri May 22 1998 - 16:11:05 CDT