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

Re: Question about SYSDATE

From: Andreas Hundt <andreas.hundt_at_merck.de>
Date: Wed, 15 Sep 1999 14:48:41 +0200
Message-ID: <37DF95A8.B3A70685@merck.de> 





Try



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



Regards Andreas




Erkki Arus schrieb:



>                                 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:48:41 CDT












Original text of this message













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