Post reply

Daylight Saving Time issue in Distribution system

  • October 17, 2002 at 1:06 pm

    #158794

    Hi there, anyone has dealed with this kind of issue before? I am in Canada, so we use Eastern Daylight Time, and in every Fall, we'd set our clock one hour back, say 3:00AM to 2:00AM.

    and here, we have a system, with SQL 2000 server and Replication. I know the subscriber server get the time from publisher, etc. But how do them handle the mysterious time period (from 2:00AM to 3:00AM)? Would the data pushed from publisher to scriber got messed up?

  • October 18, 2002 at 5:07 am

    #438867

    It should not, from my understanding under the hood everything is stored physically as an interger value that is the value of the number of seconds since Jan 1 1970, this is why a time value of 12:000AM entered will output as that date, thus it calulates the date out with the API system and uses the servers configured Time Zone to determine the actual value.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply