Jump to content
Changes to the Jaspersoft community edition download ×

timestamp filtering (literals) in query


Recommended Posts

I have a query that works in SQLBuilder (returns rows) but then I use that repository query in a DBInput component (and it adds '' -ticks- to the start and end of the query, I get an error

"Number found where operator expected"


the offending where clause is:

WHERE PLATE.DATE_TIME_STAMP >= {ts '2006-01-01 00:00:00'}

AND PLATE.DATE_TIME_STAMP <= {ts '2006-07-01 00:00:00'}


The full query runs fine in Toad and, as I said, the Jasper SqlBuilder tool. If I remove the begin/end ticks that are added when the command is displayed in the Query section of the DBInpout Properties tab, I also get an error.


How are folks doing filtering by time stamp in their queries? Is there a better approach?



ANY ideas would be great. TIA


Post edited by: momanning, at: 2007/04/24 21:29

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