Steve Jones - SSC Editor
June 15, 2020 at 12:00 am
Comments posted to this topic are about the item Getting the default Datefirst
Follow me on Twitter: http://www.twitter.com/way0utwestForum Etiquette: How to post data/code on a forum to get the best helpMy Blog: www.voiceofthedba.com
Right there with Babe
June 15, 2020 at 8:19 am
I see how using sys.languages lets you determine the default datefirst given the default language, ... but that raises the question, how does one find the default language for this instance?
June 15, 2020 at 1:01 pm
I was going to say the same thing.
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 15, 2020 at 1:21 pm
sys.syslanguages table contains first day of the week values related to language, not default date first values for instance. The question is incorrect.
June 15, 2020 at 2:23 pm
EXEC sp_configure 'default language'
June 19, 2020 at 3:57 pm
I'd say, the default DATEFIRST in a session depends on the default language of the login.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply