timestamp filtering (literals) in query

[momanning]

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

Mo

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