Re: How to check whether my Oracle database has Y2K problem?

From: Andrew Protasov <a_protasov_at_hotmail.com>
Date: Sat, 13 Feb 1999 22:49:05 GMT
Message-ID: <7a4vgv$3kg$1@nnrp1.dejanews.com>

Hi,

You should change date format on all clients too, not only on server. And this will not solve your Y2K problem. You must check, that applications do not use implicit date/varchar2 conversions. All consersions must be done through explicit to_char(x,formatmask) and to_date(x,formatmask) calls.

Of course there is a lot of other problems with Y2K.

Andrew Protasov

In article <36c226fa.258671_at_news.twsc.pouchen.com.tw>, violin.hsiao_at_mail.pouchen.com.tw (Violin) wrote:
> Hello,
> Our production Database is Oracle 7.3.2 on NetWare 4.10.
> I connect as internal/password
> select * from props$ where name = 'NLS_DATE_FORMAT';
> And return the date format : DD-MON-YY
> Does this database has Y2K problem?
> If yes,how to change the NLS_DATE_FORMAT?
> Thank you for any help!
>
> Violin.
> violin.hsiao_at_mail.pouchen.com.tw
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Feb 13 1999 - 16:49:05 CST