timestamp filtering (literals) in query

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
momanning's picture
Joined: Jan 31 2007 - 6:43am
Last seen: 13 years 8 months ago

0 Answers:

No answers yet