In Geoserver i create parametric view:
SELECT * FROM MyTable LEFT JOIN Track On MyTable.SegmentID=Track.SegmentID WHERE (DATEPART(yy, MyTable.Date)=%year% AND DATEPART(mm, MyTable.Date)=%month% AND DATEPART(dd, MyTable.Date)=%day%)
i set default values
Now i go in layer preview pick my layer and see layer with features with Date=2009-09-18.
Now i want to see features with another date. In address line i add:
But still see same features. I try another dates but not help.