c# - Query to URL conversion -


I have such a question

  select xxx from '10-26' and '2012 -10-27 '   

and URLs like

  url /? $ Filter = dates gt datetime'2012-10-26 'and the date is' Lepidated '2012-10 -27'   

and I am getting the response using this .

Now, I need over time , so I changed

  and $ filter = LastModifiedDate + ge + datetime'2012- 09-25 23:59:59 '  

But I'm getting an error:

{"odata.error": {"code": "", "Message": {"lang": "en-US", "value": "unfamiliar" Edm.DateTime 'literally' datetime'2012-09-25 12:00:00 '' at '20 ' 'Lstoddifidad GE Date Time' 2012-09-25 12:00:00 ''. "}}}

short answer

  dateTimeOffsetValue = year" - "month" - "day" t "hours": "min [": "second [ "." Partial Seconds]] ("Z" / Sign-Hour ":" Minute)   

Example: 2000-01-01T16: 00: 00.000Z


ADM: Date expression evaluates a primitive date value. Date expression should be assigned a type of value xs: see [xml-schema-2], see Section 3.3.9. The value should also be consistent with the rule date value in [OData-ABNF], that is, it should not offset any timezone.

To include the starting moment of each day from the beginning of the day to the beginning of the day, at the time of day, -rightly represents the top-open interval of intervals). For non-timed values, the top-open interval covers a non-timezone timeline unallocated, one per day. For timed values, the interval begins every minute and therefore overlaps.

  • So, what do you want here? date offset :

    Edm: DateTime offset expression evaluates a primitive date / time value with timezone offset. Date / time expression must be assigned to one type of value: xs: dateTimeStamp, [XML-Schema-2], see Section 3.4.28. It is important that the rule in [OData-ABNF] be consistent with the datetime offset value, that is, it should not be the end of the day (24:00:00).



  • Comments

    Popular posts from this blog

    Java - Error: no suitable method found for add(int, java.lang.String) -

    java - JPA TypedQuery: Parameter value element did not match expected type -

    c++ - static template member variable has internal linkage but is not defined -