Re: Date comparison question.

select * from v$parameter where upper(name) like '%DATE%';

JRStern_at_primalsys.com (JRStern) wrote:

>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:22:33 CDT