Re: JAVA TIMESTAMP
- 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)
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.
Other related posts: