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: Dates in Oracle

Re: Dates in Oracle

From: Gary Gapinski <glg_at_apk.net>
Date: Sat, 08 Dec 2001 07:16:56 -0500
Message-ID: <3C1204B8.33E807AA@apk.net> 





TC3 Racer wrote:


> 

> I have a date/time stored in table as 1007718960, this relates to sometime

> in the 07Dec01. How do I convert the integer to a date/time

> 

> Thanks

> 

> GC




long seconds = resultSet.getLong("column name");
java.sql.Timestamp timestamp = null;


timestamp = new Java.sql.Timestamp(seconds*1000);
Received on Sat Dec 08 2001 - 06:16:56 CST












Original text of this message













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