Mercurial > dive4elements > gnv-client
diff gnv-artifacts/src/test/ressources/queries.properties @ 102:994a39b084d6
Imporved JUnitTest and Bugfixing as a Result of this Improvement.
gnv-artifacts/trunk@150 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Tue, 29 Sep 2009 09:55:40 +0000 |
| parents | ce398a7a99fc |
| children | 2aae4a78e555 |
line wrap: on
line diff
--- a/gnv-artifacts/src/test/ressources/queries.properties Tue Sep 29 09:50:25 2009 +0000 +++ b/gnv-artifacts/src/test/ressources/queries.properties Tue Sep 29 09:55:40 2009 +0000 @@ -77,8 +77,8 @@ WHERE tv.TIMESERIESID = t.TIMESERIESID AND \ t.PARAMETERID IN ( ? ) AND \ tv.MEASUREMENTID IN ( ? ) AND \ - tv.TIMEVALUE > TO_DATE ('?', 'YYYY.MM.DD HH24:MI:SS') AND \ - tv.TIMEVALUE < TO_DATE ('?', 'YYYY.MM.DD HH24:MI:SS') \ + tv.TIMEVALUE > ? AND \ + tv.TIMEVALUE < ? \ ORDER BY tv.MEASUREMENTID , \ tv.TIMESERIESID , \ t.PARAMETERID , \ @@ -153,8 +153,8 @@ msv.FEATUREID in ( ? ) AND \ msv.PARAMETERID in ( ? ) AND \ mp.FEATUREID = ? AND \ - msv.TIMEVALUE >= to_date('?', 'YYYY.MM.DD HH24:MI:SS') AND \ - msv.TIMEVALUE <= to_date('?', 'YYYY.MM.DD HH24:MI:SS') \ + msv.TIMEVALUE >= ? AND \ + msv.TIMEVALUE <= ? \ order by msv.FEATUREID, \ msv.PARAMETERID, \ msv.TIMEVALUE