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 -> Question about SYSDATE

Question about SYSDATE

From: Erkki Arus <aphex_at_spin.ee>
Date: Wed, 15 Sep 1999 15:02:51 +0300
Message-ID: <7ro1ps$1vp$1@keeks.cyber.ee> 




                                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?



Thanks.



Regards, Erkki Arus


e-mail: erkki_at_spin.ee

Received on Wed Sep 15 1999 - 07:02:51 CDT












Original text of this message













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