change time zone of sql server 2005

Discussion in 'Databases' started by trade2mecom, Oct 12, 2009.

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

    trade2mecom

    Hi,
    can you tell how to chagne time zone of sql server 2005? Our time zone is GMT+5:30, and DASP time zone is different from that, so when we use getdate() function it shows different time then our current time.
     
    trade2mecom, Oct 12, 2009
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    It is not possible for us to change the timezone on the server...

    you will need to adjust the time different programmatically.
     
    Bruce, Oct 12, 2009
    #2
  3. hoagieland

    hoagieland

    The localization features of .NET let you capture the user's local time zone and language information. Look into these for adjusting dates, times, currencies and languages to fit your users needs.
     
    hoagieland, Oct 12, 2009
    #3
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