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

Home -> Community -> Usenet -> c.d.o.server -> nls_date_format question

nls_date_format question

From: Paul and Lori Brooks <brooksplc_at_erols.com>
Date: Tue, 03 Aug 1999 21:04:02 -0400
Message-ID: <37A79181.10BE1A3E@erols.com>


Does anyone know why I cannot see the full date output once I issue the command:

alter session set nls_date_format = 'DD-MON-YYYY';

It appears that this works; the column is restricted to the standard a9 width. The kicker is
that this works from a few clients, but not all.

Thanks,

Paul Received on Tue Aug 03 1999 - 20:04:02 CDT

Original text of this message

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