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 -> Re: SYSDATE and timezone

Re: SYSDATE and timezone

From: Nicolas Bronke <nb_at_trinity.de>
Date: Mon, 1 Oct 2001 14:39:48 +0200
Message-ID: <9p9o0d$ork$02$1@news.t-online.com> 





>

> sysdate from dual returns the current time IN THE servers timezone (not

> including -- the timezone component is not available with sysdate).

>

> In 9i, you can get a timestamp with timezone.  In 8i there is no timezone

> support in the database.

>



Thank you very much for the answer.



regards



Nicolas
Received on Mon Oct 01 2001 - 07:39:48 CDT












Original text of this message













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