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 -> Date format help

Date format help

From: Jane Mikityanskaya <jane_at_hnrc.tufts.edu>
Date: 1997/06/11
Message-ID: <339F144C.EC934043@hnrc.tufts.edu>#1/1

Hello,

I can't get any luck in setting up a non-default date format. After submitting a statement

SQL> alter session set nls_date_format = 'MM-DD-YYYY';

NLS_DATE_FORMAT parameter has changed to a new format. BUT browsing the actual data with the SELECT statement truncates it up to 9 characters.
Can someone told where I am wrong?

Best regards,
Jane Received on Wed Jun 11 1997 - 00:00:00 CDT

Original text of this message

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