OData query filter for dateTime range

odata breeze
user2439903 picture user2439903 · Jun 30, 2014 · Viewed 45.5k times · Source

I have a DateTime property in the data returned by a service that looks like "SDateTime":"2014-06-29T03:30:00.000".

I need to write a query to get a collection which has the date less than "2014-06-26T03:30:00.000" and greater than "2014-06-23T03:30:00.000"

How to write a filter for the dateTime?

Thanks.

Answer

Tan Jinfu picture Tan Jinfu · Jun 30, 2014

$filter=SDateTime gt datetime'2014-06-26T03:30:00.000' and SDateTime lt datetime'2014-06-23T03:30:00.000'

It works in this service: http://services.odata.org/V3/OData/OData.svc/Products?$filter=ReleaseDate%20gt%20datetime%271995-09-01T00:00:00%27%20and%20ReleaseDate%20lt%20datetime%271995-12-01T00:00:00%27

Related questions

How to consume OData service with Html/Javascript?

Our project currently uses Silverlight to consume an Odata service. This has made life pretty simple since we can just reference the OData service thus giving us generated service reference/entities. However there is some discussion on whether we should …

Read More
Any PHP framework implements ODATA protocol?

Is there any php framework that implements odata protocol, native or by extension? I need to use breezejs on the client and I hope I don't have to implement all the server side work of odata by myself. in case …

Read More
Could not load file or assembly 'System.Web.Http 4.0.0 after update from 2012 to 2013

I did the upgrade according to. http://www.asp.net/mvc/tutorials/mvc-5/how-to-upgrade-an-aspnet-mvc-4-and-web-api-project-to-aspnet-mvc-5-and-web-api-2 I get the error. Does any one else got this error? Server Error in '/' Application. Could not load file or assembly 'System.…

Read More