• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ORA-00907: missing right parenthesis - SQLException

 
Reggie McDougal
Ranch Hand
Posts: 69
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Reggie McDougal
Ranch Hand
Posts: 69
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
to_date() always require a date format


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

thanks
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic