jean.sebastien.lemay
-
Posts
2 -
Joined
-
Last visited
Community Answers
-
jean.sebastien.lemay's post in PostgreSQL timestamp parameter: could not determine data type of parameter $1 was marked as the answer
OK, I realised it was a PostgreSQL error. The solution is to force PostgreSQL to interpret the parameter as a timestamp
SELECT *FROM logWHERE CASE WHEN $P{timestampFrom}::timestamp IS NULL THEN TIMESTAMP >= '-infinity' ELSE TIMESTAMP >= $P{timestampFrom} END[/code]