Re: default time zone for a given sql 2005 instance

On Jan 8, 3:38 pm, Plamen Ratchev <Pla...@xxxxxxxxxxxxx> wrote:
SQL Server uses the timezone that is set up for Windows. However, it
depends how date/time is inserted in the table. For example, if inserted
using the server functions on the server side then it will use the
server timezone. But if date/time is send from client in different time
zone as parameter, then it has the timezone settings from the client
side. Unless the timezone offset was stored there is no way to determine
what was the originating timezone.

On SQL Server 2008 the new data type DATETIMEOFFSET has time zone awareness.

--
Plamen Ratchevhttp://www.SQLStudio.com

thanx Plamen - that's very helpful.

pat
.

Relevant Pages

  • Re: RE: Oracle Rdb on GS1280 with 7.3-2 exceeds 1 million transactions per
    ... in propogating pseudotime to processes created by the pseudotime process. ... In this age of server consolidation and the internet, ... the guy was perfectly happy for datesim to do it. ... based on the timezone of the user logging in. ...
    (comp.os.vms)
  • Re: Converting the time from one timezone to another
    ... I understand the concept of UTC, ... | a way to enter the timezone as a parameter in order to find the offset. ... Carry out some calculation at the server using a date/time pasesed ...
    (microsoft.public.dotnet.framework)
  • Re: how to make dates without timezones?
    ... because the time depends on the timezone. ... servers time for both parse and format. ... that letting the client app format using the servers timezone is ... that the bulk of the work in my app is done on the server and is ...
    (comp.lang.java.programmer)
  • Re: how to make dates without timezones?
    ... The problem is that when i load them into a java ... Date it automatically assigns the timezone. ... My application is a client server app using rmi. ...
    (comp.lang.java.programmer)
  • Re: how to make dates without timezones?
    ... example is the birthdate field. ... because the time depends on the timezone. ... that letting the client app format using the servers timezone is ... Well I just tried setting it up so my server would auto switch back ...
    (comp.lang.java.programmer)