aspose file tools*
The moose likes JDBC and the fly likes JDBC setDate (oracle driver). Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC setDate (oracle driver)." Watch "JDBC setDate (oracle driver)." New topic
Author

JDBC setDate (oracle driver).

lvkiran
Greenhorn

Joined: May 14, 2003
Posts: 3
I have a column with "DATE" as datatype ..As part of a batch process I need to insert the start date and time into that (YYYY-MM-DD HH24:MI:SS).
If i use just the Statement and the to_date function in the "values" clause it works ..but this is an existing application using "Prepared Statement" and we're migrating from sybase to oracle. When I am trying to use the setDate function it is just inserting the date part and putting zeros (00:00:00) for time part where as in sybase just the setString was taking care of everything ... Any suggestions please ...
Andy Bowes
Ranch Hand

Joined: Jan 14, 2003
Posts: 171
Have you tried using the setTimestamp() method on the Prepared Statement ?
e.g.
java.util.Date now = new java.util.Date();
ps.setTimestamp( new java.sql.Timestamp(now.getTime()) );
I think that the setDate() method only sets the date portion of the DateTime column.
HTH


Andy Bowes<br />SCJP, SCWCD<br />I like deadlines, I love the whoosing noise they make as they go flying past - Douglas Adams
lvkiran
Greenhorn

Joined: May 14, 2003
Posts: 3
Thanks Andy .. that works..
Dirk Schreckmann
Sheriff

Joined: Dec 10, 2001
Posts: 7023
lv,
Welcome to JavaRanch!
We ain't got many rules 'round these parts, but we do got one. Please change your display name to comply with The JavaRanch Naming Policy.
Thanks Pardner! Hope to see you 'round the Ranch!


[How To Ask Good Questions] [JavaRanch FAQ Wiki] [JavaRanch Radio]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC setDate (oracle driver).
 
Similar Threads
problem while inserting date field in oracle data base
Specify Date as 0000-00-00
preparestatement
Inserting formatted Date into DB from java
Remove time part from java.util.Date()