Solved

Server instance default dateformat setting

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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This article explains how to install and use the NTBackup utility that comes with Windows Server.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

830 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