Re: Set the German date format in Oracle 8i

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sun, 26 Oct 2003 23:32:54 +0100
Message-ID: <soiopvgrt7iank2gbosrcc3co1t8q2d6vk@4ax.com>

On Wed, 22 Oct 2003 15:45:47 GMT, "Robert Wehofer" <thalion77_at_graffiti.net> wrote:

>How can I set the German date format in Oracle 8i?
>
>Regards,
>Robert
>

By setting the registry variable NLS_DATE_FORMAT (winblows) or env var NLS_DATE_FORMAT (Unixes) or by creating an after-logon trigger, which calls execute immediate 'alter session set nls_date_format'. Numerous possibilities,all described in your National Language Support manual.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sun Oct 26 2003 - 16:32:54 CST