Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Convert DateTime Error

 
Jerome Donaldson
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Complete newbie to java

I am trying to do a convert from a parameter to a datetime stamp. Here is my code:
... bus_start_date between (CONVERT(DATETIME,\'args[3]\', 102)) and (CONVERT(DATETIME,\'args[4]\', 102))) ...
Exception in thread "main" java.sql.SQLException: Syntax error converting datetime from character string.

When I enter a hard coded sting instead of the parms it works ex('2008-01-02 00:00:00')

Can ANY one help please,

Thank you in advance
 
Lukasz Bajzel
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It has nothing to do with Java. You have an SQL syntax error here. What database are you using? Whatever it may be, the arg is not translating into actual value here.

Sincerely
Your friends at www.javaadvice.com
 
Jerome Donaldson
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
MSSQL Server

I cant seem to be able to get the syntax right. Can yu help
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic