Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes  ORA-00907: missing right parenthesis - SQLException Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark " ORA-00907: missing right parenthesis - SQLException" Watch " ORA-00907: missing right parenthesis - SQLException" New topic
Author

ORA-00907: missing right parenthesis - SQLException

Reggie McDougal
Ranch Hand

Joined: Sep 27, 2004
Posts: 69
I get this error when I run my sql, can anyone see it I'm not sure why its
throwing this exciption.


UPDATE product SET name = 'Bill', description = 'test', long_description = 'test', active_from = to_date(Wed Jan 05 00:00:00 EST 2005), active_to = to_date(Wed Jan 26 00:00:00 EST 2005) WHERE product_id = 100092

If some one could help?

Reg


You can never drink too much
Reggie McDougal
Ranch Hand

Joined: Sep 27, 2004
Posts: 69
I have used a different method to solve this refer to post

<a href="http://www.coderanch.com/t/301568/JDBC/java/Convert-String-date-valus-Oracle">refer to post</a>

Reg
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

to_date() always require a date format


to_date('your date','Date Format')

thanks


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ORA-00907: missing right parenthesis - SQLException
 
Similar Threads
date type "Long" range too small?
Problem with SimpleDateFormat
Need Help on Time conversion.
Get file created time
no working