Convert datetime from sql-server in javascript

Question

I have a datetime in SQL server that i return from a controller method in my MVC project using return json()

I get this format in my json-response:

time: "/Date(1409763303817)/"

I try to use this data in a table in my UI with this code:

$("#missingTime").html(new Date(data3.time).toDateString());

I get "Invalid Date" in my column.

What am i doing wrong?

Edit: Found a solution

new Date(parseInt(data3.time.replace("/Date(", "").replace(")/",""), 10)

Have a look at http://stackoverflow.com/questions/206384/how-to-format-a-microsoft-json-date — Julian Go, Sep 04 '14 at 15:21
Why don't you accept an answer? People take their time to help, the least you can do is play the game by the rules in return. — SheedySheedySheedy, Sep 08 '14 at 09:47
@SheedySheedySheedy you'r answer didn't solve it. I will add the solution i found. — Lord Vermillion, Sep 11 '14 at 12:34
The code in my answer does solve your problem. I tested it at the time and here is a [FIDDLE](http://jsfiddle.net/dmcaodha/jg63697c/) to show you that it solves it. — SheedySheedySheedy, Sep 11 '14 at 20:13
It still doesnt work in my project, but it works in the fiddle, so i'll accept ur answer. — Lord Vermillion, Sep 12 '14 at 10:55

SheedySheedySheedy · Accepted Answer · 2014-09-04T15:19:23.330

2

The JSON value you have is not a valid number to be parsed into a JavaScript Date object. A quick fix would be to strip out the UTC value (the numbers) from your string using a regular expression and pass this to your function (after parsing into a number), like so:

var regEx = /\d+/g;
var utcInfo = data3.time.match(regEx);
$("#missingTime").html(new Date(parseInt(utcInfo)).toDateString());

Although you might want to check why your JSON response is giving you the incorrect value in the first place. The value in the JSON object needs to be as follows in order for your JS code to work:

time: 1409763303817

edited Sep 04 '14 at 15:19

answered Sep 04 '14 at 14:54

SheedySheedySheedy

536
1
6
14

What should i change on the serverside? Time is a regular datetime in my object, public System.DateTime time { get; set; }. The object is returned as json with MVCs return json(object). – Lord Vermillion Sep 04 '14 at 15:02
Do you mean .Net MVC? – SheedySheedySheedy Sep 04 '14 at 15:04
Yes, a regular MVC 4 project – Lord Vermillion Sep 04 '14 at 15:09
Then, with the greatest of respect, that is no longer a JavaScript question. I have no knowledge of that framework. What you need to pass to the JavaScript Date function is a number representing the UTC. That is the set of numbers which is represented in the string you have now. How you get that out of the database is another issue entirely. – SheedySheedySheedy Sep 04 '14 at 15:16
I have edited my answer to show you what value you need to get back from the database in your JSON object, in order for your present JS code to work. – SheedySheedySheedy Sep 04 '14 at 15:20
@TobiasOlofsson I am not sure why you won't accept the answer, because the code I have given you will achieve what you asked for. – SheedySheedySheedy Sep 05 '14 at 14:55

score 0 · Answer 2 · answered Sep 04 '14 at 15:24

0

If you take use of the MVC-Model the Controller-Layer should convert the time into a format the View can handle.

See, a Time is more than Minutes, Hours and Seconds. Its depends on the Timezone the calling Browser physicaly is.

answered Sep 04 '14 at 15:24

Grim

1,938
10
56
123

Convert datetime from sql-server in javascript

2 Answers2