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: Michael Mehling <m.mehling_at_atos-group.de>
Date: Wed, 15 Sep 1999 14:48:58 +0100
Message-ID: <7ro52i$8tv$1@news.pop-stuttgart.de> 





Nothing is wrong. Oracle stores date in your required format! Query the date
as follows:


>> select to_char(yyy,'DD-MM-YYYY HH24:MI:SS') from xxx;


and you will get the result.


Yours


mm


Erkki Arus <aphex_at_spin.ee> schrieb in im Newsbeitrag:
7ro1ps$1vp$1_at_keeks.cyber.ee...


>




Received on Wed Sep 15 1999 - 08:48:58 CDT












Original text of this message













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