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
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