Re: Help : Converting Dates to Chars

From: <rezaferry_at_my-deja.com>
Date: Tue, 19 Sep 2000 04:49:11 GMT
Message-ID: <8q6r81$d5g$1@nnrp1.deja.com>

In article <39C5F6BF.689370EC_at_NOSPAMramboll-it.dk>, mhr_at_NOSPAMramboll-it.dk wrote:

> One way is to change the default date format in order to produce the
> formatting of dates that you want. This could be done within your
session
> and thereby avoiding influencing other users/applications conencted
to the
> database. In SQL*PLUS the default date format is change with for
example:
>
> (c:\tmp) SQL> alter session set nls_date_format = 'dd-mm-yyyy
hh24:mi:ss';
>
> Session altered.

Thanks for the answer.

A follow up question.

What if I want it to influence all other users/applications connected to the database what do I alter?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 18 2000 - 23:49:11 CDT