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: to_date/to_char

Re: to_date/to_char

From: Sharkie <sharkie2_at_my-deja.com>
Date: Wed, 29 Mar 2000 20:54:30 GMT
Message-ID: <8btqht$oge$1@nnrp1.deja.com>


In article <954352245.1531.5.pluto.d4ee154e_at_news.demon.nl>, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> Simple.
> As d is a date column, you are getting implicit conversion in your
> dbms_output call.
> The default date format is dd-mon-yy, which is exactly what you are
getting
> returned.

True, you can change that default by:
alter session
set nls_date_format='DD-MON-YY HH24:MI:SS';

--
If the human brain were so simple
that we could understand it,
we would be so simple we couldn't.
-Makes Sense... don't it?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 29 2000 - 14:54:30 CST

Original text of this message

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