Query filter date comparison

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Query filter date comparison

makoychan
Hi,

is there any way to do date comparison filter without converting the date
into string? Because i am using it like this on my layers

 ToString(ScheduleDate, 'MM/DD/YYYY') = ToString( CurrentDate( )
,'MM/DD/YY')

its seems quite slow



--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html
_______________________________________________
mapguide-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapguide-users
Reply | Threaded
Open this post in threaded view
|

Re: Query filter date comparison

Martin Morrison
What FDO provider are you using?

Martin Morrison
Application Engineer
Main Office: 540-345-1410 Toll Free: 888-355-0081
Products ǀ Training ǀ Service ǀ Tech Support
 
Please visit microcad3d.com for more information!
 


-----Original Message-----
From: mapguide-users <[hidden email]> On Behalf Of makoychan
Sent: Tuesday, May 26, 2020 9:53 AM
To: [hidden email]
Subject: [mapguide-users] Query filter date comparison

Hi,

is there any way to do date comparison filter without converting the date into string? Because i am using it like this on my layers

 ToString(ScheduleDate, 'MM/DD/YYYY') = ToString( CurrentDate( )
,'MM/DD/YY')

its seems quite slow



--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html
_______________________________________________
mapguide-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapguide-users
Reply | Threaded
Open this post in threaded view
|

Re: Query filter date comparison

makoychan
SQL Server Spatial



--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html
_______________________________________________
mapguide-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapguide-users