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

Re: date format

From: <gareth_at_jamms.org>
Date: 5 Jan 2006 05:10:30 -0800
Message-ID: <1136466630.322008.212990@g14g2000cwa.googlegroups.com>


>> how do I make output as "02-MAR-05 12:20:00" without using to_char() process.

Set your NLS_DATE_FORMAT appropriately. e.g.

SQL> select sysdate from dual;

SYSDATE



05-JAN-06 SQL> alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';

Session altered.

SQL> select sysdate from dual;

SYSDATE



05-JAN-2006 13:09:05 HTH -g Received on Thu Jan 05 2006 - 07:10:30 CST

Original text of this message

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