Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: date format question

Re: date format question

From: Rajan <sestri_at_hotmail.com>
Date: Tue, 20 Apr 1999 17:52:21 -0500
Message-ID: <371D0524.E9A907B1@hotmail.com>


Gennady,
Change the NLS_DATE_FORMAT in the client machine's registry to 'dd-mon-yyyy'.
This will solve the problem..
srajan

Gennady wrote:

> Hello.
> Could anybody give me a hint how to change
> date type data format from 4/20/99 12:50:54
> to 20-APR-99 (only date, no time)?
>
> Please, help
> Gennady
Received on Tue Apr 20 1999 - 17:52:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US