• From: Nigel Thomas <nigel_cl_thomas@xxxxxxxxx>
  • To: oracle.tutorials@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 20 Sep 2007 03:53:15 -0700 (PDT)


According to JDBC faq 
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
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.

Other related posts: