I have found the FDO "TIMESTAMP" command to works for me:
"DateColumn" > TIMESTAMP '2009-01-30 23:25:00'
It might not work on all providers though.
Regards, Kenneth Skovhede, GEOGRAF A/S
Traian Stanev skrev:
This is more of a workaround than a solution to the problem, but...
You can try to make some expression that converts the date to a string
of the form YYYY-MM-DD and then write your filter as a string
comparison. You can compare dates in this format using simple string
comparisons (lexicographical order matches chronological order).
Traian
*From:* [email protected]
[mailto:[email protected]] *On Behalf Of *Darren
Karasiuk
*Sent:* Monday, February 02, 2009 2:09 PM
*To:* [email protected]
*Subject:* [mapguide-users] SQL datetime trouble
Hello, I've been trying to use MapGuide OS and have been able to show
a themed layer when I filter by the unique row id and equipment id.
Instead of using row IDs, I need to filter the data by date and time
ranges. So far, when ever I use a datetime field to filter, the
entire database is returned. I assume if the filter isn't correct
then it's nulled and no filter gets applied, so that's why I get the
entire database.
Can anyone tell me the correct method of filtering a layer by a date
range, please?
I've been using Map Guide Studio trial from Autodesk and tried many
different ways of filtering using ToDate() and Extract() with no luck.
I couldn't find any filtering information with the FDO.
I'm using SQL Server 2008. The table has both lat and long fields as
well as its respective geospatial field.
Thanks for any help!
Darren
------------------------------------------------------------------------
_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
