Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: to_date/to_char
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