Regional Settings on the Database

Discussion in 'Databases' started by CopperKoala, Jan 27, 2009.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. CopperKoala

    CopperKoala

    Hi

    I have purchased the european hosting however the database and server are in US settings??? so my dates and currency is all wrong, can this be changed? I really do not want to write this formatting....please help?
     
    CopperKoala, Jan 27, 2009
    #1
  2. JorgeR

    JorgeR DiscountASP.NET Staff

    JorgeR, Feb 2, 2009
    #2
  3. CopperKoala

    CopperKoala

    I have ran EXEC sp_defaultlanguage 'SQL2005_583167_dcs_user', 'British'; its says Command(s) completed successfully.

    however this is not changing the language....any ideas?
     
    CopperKoala, Feb 3, 2009
    #3
  4. JorgeR

    JorgeR DiscountASP.NET Staff

    We recommend that you use the Convert function SELECT CONVERT(varchar(15), Getdate(),103) when inputting the date to your database - http://msdn.microsoft.com/en-us/library/ms187928.aspx (for the style). Please recall that the SQL engine sends the data in binary format. If you login using SSM08 and use the command 'select getdate ()' you will get the time back in Brtish English


    junior

    DiscountASP.NET

    www.DiscountASP.NET
     
    JorgeR, Feb 7, 2009
    #4
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page