Solved

Server instance default dateformat setting

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

Make managing Office 365 email signatures a breeze

Are you using Office 365? Having trouble trying to set up email signatures for your users? Getting stressed out managing multiple signatures? Need an easier way to manage? We have a solution for you, try the most-user friendly and powerful signature management tool on the market.

Question has a verified solution.

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

Issue: One Windows 2008 R2 64bit server on the network unable to connect to a buffalo Device (Linkstation) with firmware version 1.56. There are a total of four servers on the network this being one of them. Troubleshooting Steps: Connect via h…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
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…

863 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

25 Experts available now in Live!

Get 1:1 Help Now