How to change DateTime to U.S format?

chobo2 · March 8th, 2009, 02:18 AM

Hi

My format is set to Canadian format but the calendar control I am using sets it to American format. I could probably change the calender control but when I launch my site. The hosting company most likely will have it in U.S format.

So is there a way I can just set my website to just do U.S format?

Like something I just stick in the web.config file or something like that.

Also how do I change my sql server to do U.S format as well.

Thanks

Old Pedant · March 8th, 2009, 03:08 AM

SQL Server: You can prefix any query with
SET DATEFORMAT MDY;
SQL Server accepts MDY, DMY, YMD (and even YDM though why I dunno).

Note that you only need to do this once per open connection, so if you execute multiple queries on the same connection, you only need this once. But it won't hurt to do it with each query. You can also change the installation default, but I dunno if you can change the default on a per-user basis.

Might I suggest you find a calendar control that isn't so braindead that it can't allow you to choose your preferred format? If you are talking about a "popup" or "popon" calendar written mostly in JavaScript, I've got one that not only allows you to specify the date format but even allows you to specify which day of the week to start on. 100% HTML and JS, no ASP.NET code needed/wanted.

Imar · March 8th, 2009, 05:11 AM

Hi there,

You can set the culture and uiCulture properties of the Globalization element in web.config:

http://msdn.microsoft.com/en-us/library/hy4kkhe0.aspx

Once you do that, dates, numbers and other presentational elements will adapt to the culture you set. If you set it to auto, it'll adapt to the user's preferred "accept language"...

Quote:

Might I suggest you find a calendar control that isn't so braindead that it can't allow you to choose your preferred format?

Who says the calendar he's using is braindead? The OP is just asking *how* to change it.

Cheers,

Imar

chobo2 · March 8th, 2009, 02:56 PM

Quote:

Originally Posted by Old Pedant

SQL Server: You can prefix any query with
SET DATEFORMAT MDY;
SQL Server accepts MDY, DMY, YMD (and even YDM though why I dunno).

Note that you only need to do this once per open connection, so if you execute multiple queries on the same connection, you only need this once. But it won't hurt to do it with each query. You can also change the installation default, but I dunno if you can change the default on a per-user basis.

Might I suggest you find a calendar control that isn't so braindead that it can't allow you to choose your preferred format? If you are talking about a "popup" or "popon" calendar written mostly in JavaScript, I've got one that not only allows you to specify the date format but even allows you to specify which day of the week to start on. 100% HTML and JS, no ASP.NET code needed/wanted.

Well you can send it to me I like to see it. I am using the jquery one and you can change the format of how the date is formated but I just would think it might be more trouble then it is worth.

Like when I go live I am pretty sure my hosting company will have sql and stuff set as U.S so it probably more hassle to get them to change it then it is worth.