POSGIS timefilter date_trunc bug

[Denis Nadeau]

Hi,

I found the solution to this problem.

When using shp2pgsql the data type for the date and time column are set to
varchar datatype.

Make sure that the table was create with DATE datatype for timestamps
columns.

Example:

CREATE TABLE "mapserver" (gid serial PRIMARY KEY, "location" varchar, "time"
date, "imgdate" date);

The WMS time filter works fine now with PostGIS connection.

Regards,
Denis
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060628/11c25843/attachment.html