RE: [mapguide-users] SQL datetime trouble

2009-02-03 Thread Darren Karasiuk
_ From: mapguide-users-boun...@lists.osgeo.org [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Kenneth Skovhede, GEOGRAF A/S Sent: February 3, 2009 12:41 AM To: MapGuide Users Mail List Subject: Re: [mapguide-users] SQL datetime trouble I have found the FDO "T

Re: [mapguide-users] SQL datetime trouble

2009-02-02 Thread Kenneth Skovhede, GEOGRAF A/S
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

RE: [mapguide-users] SQL datetime trouble

2009-02-02 Thread Traian Stanev
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 -MM-DD and then write your filter as a string comparison. You can compare dates in this format using simple string comparisons (lexicographi