Dates in .net vs in javascript

Question

I have a ASP.NET WEB.API 4 and a Controller returning the following json:

{   date: "2013-03-14T00:00:00"   }

I parse it on the client (JavaScript):

date = new Date(json.date); // json.date being "2013-03-14T00:00:00"

Later I do a POST and in the body the date has changed format to

{   date: "2013-03-13T23:00:00.000Z"   }

My guess was that some time zone stuff has been added by JavaScript or the browser?

Because of DB storing dates as int (yyyymmdd) I do the following convertion:

public static int ToInt(DateTime date)
{
    return date.Year * 10000 + date.Month * 100 + date.Day;
}

The resulting int is then one day off :(

However if I do

date.ToLocalTime()

before calling the ToInt method, it looks fine.

Have I understood this correctly and is ToLocalTime() a sufficient solution or do I need to spend a day reading up on UTC dates in .NET and JavaScript?

Thanks!

welcome to the hell called "JS Date" try using a library like datejs or momentjs :/ — Nikola Sivkov
– Nikola Sivkov, Commented Apr 6, 2013 at 14:12
You're storing dates as int (yyyymmdd)??? What database do you use? — Bergi
– Bergi, Commented Apr 6, 2013 at 15:30
@Bergi sql 2000. The problem is the ppl who wrote the sw back in the 90's :) — Cotten
– Cotten, Commented Apr 8, 2013 at 5:02

Piotr Stapp · Accepted Answer · 2013-04-06 14:09:54Z

1

In my opinion you will get better result if your controller will return date in ZULU format. So before sending use: ToUniversalTime (http://msdn.microsoft.com/en-us/library/system.datetime.touniversaltime.aspx) Than the result also will be in ZULU format, so you don't have to convert it to LocalTime

answered Apr 6, 2013 at 14:09

Piotr Stapp

19.9k11 gold badges72 silver badges118 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bergi · Accepted Answer · 2013-04-06 15:35:24Z

1

date = new Date(json.date); // json.date being "2013-03-14T00:00:00"

And what timezone is that json.date in? If there's no information about this, the JS Date constructor will assume it is the client's local timezone (and that is quite random). If you want it to be UTC, just add "Z" after your ISO-datestring:

date = new Date(json.date+"Z");

Also always use the [gs]etUTC(FullYear|Month|Date|…) methods then.

answered Apr 6, 2013 at 15:35

Bergi

671k162 gold badges1k silver badges1.5k bronze badges

Collectives™ on Stack Overflow

Dates in .net vs in javascript

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related