Does this page help Deepak http://download-uk.oracle.com/otn_hosted_doc/jdeveloper/904preview/jdbc- javadoc/oracle/sql/TIMESTAMP.html ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of DBA Deepak Sent: 20 September 2007 11:14 To: oracle-l Subject: JAVA TIMESTAMP 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 BJSS Limited, 1st Floor Coronet House, Queen Street, Leeds LS1 2TW. Registered in England with company number 2777575. http://www.bjss.co.uk