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
Post a Comment