sql error still

[ktrinad]

By: vivek srinivasan - viveksrinivasan

sql error still

2003-09-30 07:10

As sachin suggested i wrote a sql query like

select * from emp where trandate<='$P!{current_date}' and trandate>='$P!{current_date}'

but when i copile it,i get the following error message

java.sql.SQLException: [Microsoft][sqlServer 2000 Driver for JDBC][sqlServer]Syntax error converting datetime from character string.

What should be done??Any ideas??

Thanks,

Vivek

 

 

 

 

By: Giulio Toffoli - gt78

RE: sql error still

2003-10-02 02:55

Try to execute first the query manually to learn the right syntax (could be something like

 

trandate >= #2003-10-3#

 

 

Giulio