Deepak According to JDBC faq http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#08_01 java.sql.timestamp is mapped to TIMESTAMP by default (versions 9.2 onward). Are you not using JDBC? or using an earlier version? Make sure you haven't enabled V8 compatibility, for example by using -Doracle.jdbc.V8Compatible="true" in your java command line Cheers Nigel ----- Original Message ---- From: DBA Deepak <oracle.tutorials@xxxxxxxxx> 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.