Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SYSDATE

SYSDATE

From: JBB <merci_at_pasdespam.fr>
Date: Tue, 11 Oct 2005 18:29:25 +0200
Message-ID: <434be86f$0$20834$636a55ce@news.free.fr> 





Is SYSDATE command concerned with Time Zones ?
and  TO_DATE function ?



SELECT TO_DATE(SYSDATE,'YYMMDDHH24MISS') FROM DUAL;


Does the time zone depend on Oracle installation or the underlying OS ?



Thanks.
Received on Tue Oct 11 2005 - 11:29:25 CDT












Original text of this message













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