Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-06 : 07:48:47
|
| Paul writes "Hi, I built Windows 2000 server with British UK format, then loaded SQLServer 2000. But, when I run SELECT dateformat, name FROM master.dbo.syslanguages WHERE langid = @@default_langid go dbcc useroptions It returns dmy British language us_english dateformat mdy But, I want dbcc useroptions also return language uk_english dateformat dmy Does anybody can help me. Thanks Paul" |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-10-06 : 09:14:06
|
| SQL Server is NOT returning the date in any format. It is returning the date VALUE. Query Analyzer is formatting the date and displaying it. Look at formatting/display for dates options in QA. - Jeff |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-10-06 : 11:59:29
|
Damn...learned something new..(again...)BOL says it's meant for ordering the dateAND it's so cool that MS decided to denormalize the catalog..quote:
months nvarchar(372) Comma-separated list of full-length month names in order from January through December, with each name containing as many as 20 characters.
And I was gonna say..why don't they use identity here...and when I looked, I thought they did...BUT THEY DONT...it's smallint without identity...guess they don't want the unexpected to happen...betcha it was earlier...don't know...Brett8-)SELECT @@POST FROM Brain ORDER BY NewId()That's correct! It's an AlphaNumeric! |
|
|
|
|
|
|
UK date format