Date Time Issues on Windows Server 2012 R2

Question

0.00/5 (No votes)

See more:

Hi,

I am faced with an issue that I find really weird.

Currently we have a system that is working fine on Windows Server 2008 R2 but decided to migrate the system to Windows Server 2012 R2.

My date formats have now gone off on the new server and it ignores the formatting that is placed on my text box. The formatting still works perfect from the 2008 box.

I did write code to get around this issue in 1 place but there are tons of places that will need the code change and the client refuses this.

Is there some update that could be missing from the box or a setting that can be changes in order to get around this.

The date format that I want is dd/MM/yyyy but on the 2012 box it goes as dd-MM-yyyy for some reason.

thanks

Posted 15-Jul-15 0:52am

Kats2512

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2015-07-15T01:27:00

Solution 1

The default date format is controlled with the language settings of the database. So check your instance (and database) configurations. If I recall correctly, dd-mm-yyyy is the default format for U.S. English.

Date format can also be set using SET DATEFORMAT[^] to override language specific setting.

But in the long run I'd suggest modifying the program so that language settings do not matter. Valus should always be handled using parameters and if literals are needed for some reason they should always be converted properly using for example CONVERT function.

Posted 15-Jul-15 1:27am

Wendelius

Updated 15-Jul-15 1:28am

v2

Comments

Kats2512 15-Jul-15 7:39am

yes it is default and works fine in the 2008 box, on 2012 it does not format to how I want it.

Wendelius 15-Jul-15 7:45am

On the 2012 database try running
dbcc useroptions
What are the values of
- language
- dateformat
- datefirst

Kats2512 15-Jul-15 7:47am

it is a 2008 database, 2012 server software

Wendelius 15-Jul-15 7:49am

Yep, sorry about the wrong number. What were the results?

Kats2512 15-Jul-15 7:51am

language - us_english
dateformat - mdy
datefirst - 7

Wendelius 15-Jul-15 7:55am

Few questions
- Does the client program using SQL Server run on this server?
- What connection type it uses, native client, ODBC,...
- Does the server have the same regional and language settings in Windows as the old one did.

Kats2512 15-Jul-15 8:03am

yes, native and they are both the same

Wendelius 15-Jul-15 8:10am

That's actually quite odd since the date format you use does not match with the date format setting (mdy) so perhaps an implicit conversion is taking place.

What happens if you change the dateformat to dmy

Kats2512 15-Jul-15 8:12am

I am not allowed to do that as it is a client box, not my own organizations box.

Wendelius 15-Jul-15 8:17am

Regarding to this[^] it would probably change the behaviour to the direction you want.

Kats2512 31-Jul-15 10:24am

I got this issue sorted on my own :) eventually used culture info and set it to en-GB in the page load event.