Question

168

Format of DateTimeOffset in OData

rated 0 times [ 174] [ 6] / answers: 1 / hits: 16040 / 10 Years ago, tue, january 20, 2015, 12:00:00

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!

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

jaelynncherokeeg

Add To Favorites

Follow

Total Points: 697

Total Questions: 109

Total Answers: 104

Location: France

Member since Thu, Mar 18, 2021

3 Years ago

jaelynncherokeeg questions

1 NextJS load external image Amazon

Thu, May 27, 21, 00:00, 3 Years ago

1 Create an Array of Favorite fruits Object

Fri, Jan 24, 20, 00:00, 4 Years ago

1 React Testing Library - Avoid getBy?

Thu, Nov 14, 19, 00:00, 5 Years ago

1 How do I POST data to a .NET Core Web API using the fetch() javascript method

Thu, Sep 26, 19, 00:00, 5 Years ago

1 Yarn Link All Packages/Workspaces

Wed, Sep 18, 19, 00:00, 5 Years ago

View All

answered 10 Years ago carolynt · Accepted Answer

First 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'