Re: Question about SYSDATE

From: Ben Ryan <benryan_at_my-deja.com>
Date: Wed, 15 Sep 1999 16:07:03 GMT
Message-ID: <7rog6s$k5n$1@nnrp1.deja.com>

In article <7ro1ps$1vp$1_at_keeks.cyber.ee>, "Erkki Arus" <aphex_at_spin.ee> wrote:
> Hi
>
> I have a table xxx with column yyy, which is specified as DATE, and
the
> default value is set to SYSDATE. Problem is, I get the date like DD-
MM-YY,
> put I need date and time like DD-MM-YYYY HH24:MI:SS. What I have done
wrong?

Nothing, except you are using a default mask which does not show the time. Try..

SELECT TO_CHAR(yyy,'DD-MM-YYYY HH24:MI:SS') FROM xxx;

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 15 1999 - 11:07:03 CDT