Solved

Server instance default dateformat setting

Posted on 2008-10-24
2
498 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
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

To effectively work with Diskpart on a Server Core, it is necessary to write some small batch script's, because you can't execute diskpart in a remote powershell session. To get startet, place the Diskpart batch script's into a share on your loca…
You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

758 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now