Jump to content
Changes to the Jaspersoft community edition download ×

sql error still


Recommended Posts

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







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#




Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...