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: How to set Date/Timestamp

Re: How to set Date/Timestamp

From: damorgan <damorgan_at_exesolutions.com>
Date: Fri, 08 Mar 2002 19:09:12 GMT
Message-ID: <3C890C6A.FA934717@exesolutions.com>


I'm not sure if this answers your question but:

SELECT SYSDATE
FROM dual;

will get you the current date and time from the database server.

Daniel Morgan

nagendra rai wrote:

> Hello,
> I am trying to set and get timestamp from oracle by using
> JDBC. I want to read the timestamp in UTC. I am using a calendar
> havin timezone UTC. It is not working. Could somebody help me
> by providing some information on how to set and get dates to data database.
>
> Thanks
> Nagendra
Received on Fri Mar 08 2002 - 13:09:12 CST

Original text of this message

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