Re: NLS of Oracle and Regional Settings of Windows

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 05 Jun 2007 21:19:11 +0200
Message-ID: <f44cvc$jv1$1@news5.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

vmohanaraj_at_gmail.com wrote:
> Hi,
>
> I need to format a date using the windows Regional setting at the
> server side.
> This formatting should be perfomed irrespective of the NLS settings of
> the oracle server.
> The version of the oracle server used is 9.2.0.1.0.
>
> I would appreciate your help in this regard?
>

Absurd.

If I were to use your server, should I understand your local calendar? Of course not - I want it in my local calendar!

Just out of curiosity - why do you need to format it server-side, where basically, Oracle stores dates as a number? What is the scenario, business case if you like, behind all this?

-- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGZbcvLw8L4IAs830RAhcaAJ9j+crhE8CRWsf8ov5l3BF9BCrm7QCfQoz6 IzYg1frjDLWOzz7y1ogNxps=
=duKG
-----END PGP SIGNATURE----- Received on Tue Jun 05 2007 - 14:19:11 CDT