|
Home > Archive > MS SQL Server > November 2006 > SQL SERVER 2000 Date Formats "British English"
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL SERVER 2000 Date Formats "British English"
|
|
| rogerdtaylor@gmail.com 2006-11-09, 7:13 pm |
| Anyone help !
Anyone tell me how to force SQL Server 2k to output dates in british
english format.
so far i've done the following and everytime it shows as a US date:
Select @@Language
** Reports British English
>From QA :-
EXEC sp_configure 'show advanced option', '1'
RECONFIGURE
EXEC sp_configure
shows langid 23 (british english)
** shows US date format
>From Enterprise Man :- Security > logons > account (set date formats to
british english)
> Restarted service
** Still shows US date format
> Rebooted Machine - just to make sure
** Still shows US date format
Checked the regional settings for the account that the SQL Server
service is running under and made sure that its also British English
** Still shows US date format
Added Language setting to Connect string
** Still shows US date format
Can someone give me any pointers !
cheers in advance
| |
| Tibor Karaszi 2006-11-09, 7:13 pm |
| When a client requests datetime data, the engine sends it in a binary format, and the client
application formats it into something human readable. So, the engine has nothing to do with this.
What application are you using? This is where you need to look. Query Analyzer, for instance has an
option to respect regional setting when displaying datetime data.
More information at http://www.karaszi.com/SQLServer/info_datetime.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
<rogerdtaylor@gmail.com> wrote in message
news:1163089865.394179.62540@k70g2000cwa.googlegroups.com...
> Anyone help !
>
>
> Anyone tell me how to force SQL Server 2k to output dates in british
> english format.
> so far i've done the following and everytime it shows as a US date:
>
> Select @@Language
> ** Reports British English
>
>
> EXEC sp_configure 'show advanced option', '1'
> RECONFIGURE
> EXEC sp_configure
>
> shows langid 23 (british english)
>
> ** shows US date format
>
> british english)
> ** Still shows US date format
> ** Still shows US date format
>
> Checked the regional settings for the account that the SQL Server
> service is running under and made sure that its also British English
> ** Still shows US date format
>
> Added Language setting to Connect string
> ** Still shows US date format
>
>
> Can someone give me any pointers !
>
> cheers in advance
>
| |
| sqldood@googlemail.com 2006-11-09, 7:13 pm |
| Try looking in the registry under hkey_users\.default\control
panel\international thats the default setting for the system itself you
can explicitly specify the date format there.
Let me know if it helps.
rogerdtaylor@gmail.com wrote:
> Anyone help !
>
>
> Anyone tell me how to force SQL Server 2k to output dates in british
> english format.
> so far i've done the following and everytime it shows as a US date:
>
> Select @@Language
> ** Reports British English
>
>
> EXEC sp_configure 'show advanced option', '1'
> RECONFIGURE
> EXEC sp_configure
>
> shows langid 23 (british english)
>
> ** shows US date format
>
> british english)
> ** Still shows US date format
> ** Still shows US date format
>
> Checked the regional settings for the account that the SQL Server
> service is running under and made sure that its also British English
> ** Still shows US date format
>
> Added Language setting to Connect string
> ** Still shows US date format
>
>
> Can someone give me any pointers !
>
> cheers in advance
| |
| MarkusB 2006-11-09, 7:13 pm |
|
Roger,
the "default language" option in sp_configure has nothing to do with
regional settings or date format. For getting different date formats
use the CONVERT function.
Something like this should work for you:
SELECT CONVERT(varchar(25),
Getdate(),103)
Markus
| |
| Paul Ibison 2006-11-09, 7:13 pm |
| The other responses hold, but to add another suggestion, try changing the
default language of the login you're using - this determines your default
date format.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|
|
|
|
|