I have two JavaScript Date
objects. I need to do an OData query between these two Date
objects. The information I'm querying has a field called createDate
which is a DateTimeOffset
. From my understanding, I can do something like this:
entities?filter=((createDate ge [Date1]) and (createDate le [Date2]))
My question is:
- What format is a DateTimeOffset?
- How do I convert a JavaScript Date object to DateTimeOffset format?
Thank you!
I have two JavaScript Date
objects. I need to do an OData query between these two Date
objects. The information I'm querying has a field called createDate
which is a DateTimeOffset
. From my understanding, I can do something like this:
entities?filter=((createDate ge [Date1]) and (createDate le [Date2]))
My question is:
- What format is a DateTimeOffset?
- How do I convert a JavaScript Date object to DateTimeOffset format?
Thank you!
Share Improve this question asked Jan 20, 2015 at 14:35 xam developerxam developer 1,9836 gold badges29 silver badges39 bronze badges1 Answer
Reset to default 15First it depends your version of OData service. OData V4 is not compatible with OData V3.
OData V4
Format of DataTimeOffset please refer to CSDL spec of OData V4
An example of filtering the DateTimeOffset is http://services.odata.org/V4/TripPinService/People('russellwhyte')/Trips?$filter=StartsAt eq 2014-01-01T00:00:00Z
OData V3
Format of DataTimeOffset please refer to CSDL spec of OData V3
And example of filtering the DateTimeOffset is http://services.odata.org/V3/OData/OData.svc/Products?$filter=ReleaseDate gt datetime'1995-09-01T00:00:00'