invalid DateTime in get method

Question

I have a variable called TrackingDate with the type datatime2(7) in sql-server and Nullable<DateTime> in c#. when calling my GET method this is what I get in my JsonResult response:

TrackingDate: "/Date(1563271286005)/"

But the value in my table is actually "2019-07-16 14:31:26.0053912"

What's the problem?

I guess `1563271286005` is your `DateTime` in `Ticks`, if you want to convert it into specific format then use `.ToString()` — Prasad Telkikar, Jul 13 '19 at 13:04
Possible duplicate of [How do I format a Microsoft JSON date?](https://stackoverflow.com/questions/206384/how-do-i-format-a-microsoft-json-date) — CodingYoshi, Jul 13 '19 at 13:05
You've omitted all mention of your data access method and your serialization mechanism. Please show your code. — Aluan Haddad, Jul 14 '19 at 13:22

score 0 · Answer 1 · answered Jul 13 '19 at 13:07

0

Without more information it is difficult to say for sure, but based on the JsonResult you are not converting the TrackingDate variable correctly from a DateTime to a string. This post might be able to help you out.

answered Jul 13 '19 at 13:07

Slimelord

59
1
7

score 0 · Answer 2 · answered Jul 14 '19 at 12:50

0

It seems like the JSON serializer, serialize the date in a wrong way.

try to set the JSON serializer setting "DateFormatString" to "yyyy-MM-dd HH:mm:ss.fffffff"

answered Jul 14 '19 at 12:50

Sasha Pasternak

1
3

invalid DateTime in get method

2 Answers2