Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Server instance default dateformat setting

Posted on 2008-10-24
2
Medium Priority
?
512 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  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…
Suggested Courses

876 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