Solved

Server instance default dateformat setting

Posted on 2008-10-24
2
504 Views
Last Modified: 2013-12-05
Does it exist ? Is it connected to:
Our setting changed and I don't know why and where.
So all the sp's that that expect data to be in ymd is now ydm and conversion varchar->date fails with out-of-range datetime.

Grega
0
Comment
Question by:gregajesih
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 31

Expert Comment

by:Paranormastic
ID: 22799518
Are all of your entries like this?  

http://www.eggheadcafe.com/software/aspnet/29397815/date-time-format-for-latv.aspx

http://www.vbforums.com/archive/index.php/t-432252.html

You might try reposting this under the SQL 2005 zone for better results if these don't help...
0
 

Accepted Solution

by:
gregajesih earned 0 total points
ID: 22810762
Dear Paranormastic,

thank you for your effort. Though your answer was kind of sloppy and did not give solution. It appears to me that you did not read it thoroughly. I did not ask how to parse format, I was asking about default settings. Finally, we did more Googling and found the answers.
Here is the correct answer: default language specifies the dateformat. So look under login's default language and you'll know how date data will be interpreted. The order it is stored in DB is in this case irrelevant.

Case closed.
I'll five you 1/4 of poins designated if I manage to find out how.
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

OfficeMate Freezes on login or does not load after login credentials are input.
Resolving an irritating Remote Desktop connection that stops your saved credentials from being used.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
Suggested Courses

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question