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

Home -> Community -> Mailing Lists -> Oracle-L -> JAVA TIMESTAMP

JAVA TIMESTAMP

From: DBA Deepak <oracle.tutorials_at_gmail.com>
Date: Thu, 20 Sep 2007 15:44:19 +0530
Message-ID: <75aa80160709200314h475c66fh2c997c7cc5cae93c@mail.gmail.com>


Hi Experts,

Is there any built-in SQL function which can convert JAVA Timestamp to Oracle TIMESTAMP data type. I need this to partition a table based on the TIMESTAMP(JAVA TIMESTAMP). I want to partition based on the DAY OF THE MONTH part of the Timestamp.

Any help on this is highly appreciated.

--

Regards,

Deepak
Oracle DBA

--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 20 2007 - 05:14:19 CDT

Original text of this message

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