TimeToCodeTheRoad
Reputation: 7312
Database: Can java.sql.Timestamp be stored in a oracle database?
I wanted to know if java.sql.Timestamp can be stored in a oracle database. In teh oracle database the column type is TIMESTAMP? Sorry, i can not try it out myself as I dont have a oracle database, and i need it urgently for a project!
Upvotes: 0
Views: 2875
Answers (2)
user330315
Reputation:
In addition to cagcowboy's answer: you can even store a java.sql.Timestamp into an Oracle DATE column (as Oracle's DATE includes a time part)
Btw: details about the Oracle data types can be found in the manual, you don't need a running Oracle for that:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm#sthref116
Upvotes: 2
Related Questions
- Timestamp to date | Oracle DB
- How to enter timestamp format from java to oracle database that also has format timestamp?
- Using JAVA to store date/time info in the DB?
- Storing timestamp in a SQL database
- how to get timestamp from oracle DB using jdbc
- Can we use java.util.Date for sql or oracle operations?
- Java Calendar/Date to SQL Timestamp / Oracle Database
- Using a java.sql.Timestamp object in an sql query
- Converting oracle.sql.timestamptz to java.sql.Timestamp
- Sql timestamp to Java date?