Time zones

  • Thread starter Thread starter lou
  • Start date Start date
L

lou

I'm not sure where to post this question. It's kind of strange.

We have software on client machines that takes info and sends it to our
server (to an SQL Server 2000 database) through a web service.
The client machines are all across the US, different time zones and such.
Our server is in the Pacific time zone.
When the date and time are sent into the server, it appears that the time is
being converted to PST, so there is a descrepancy between the time the user
has enter and what is being stored on our server.

What's up with that? I've tested by changing the time zone on my
development machine and the first couple of tries did the same and reported
different times, but when I stepped throught the Web Service, it stopped
doing it - the time was stored as entered in the software.

To re-iterate:
There are three phases: client enters data into the software --> data is
sent to the Web Service --> the web service moves the data to the SQL Server
2000 database.
As far as I can see it's happening in the code, but I don't really see why
it would matter at all what time zone the data came from.

I just thought I'd put this question out to see if anyone had encountered a
similar situation.
 
Don't know if it will help you debug, but you might want to try:

TimeZone.CurrentTimeZone.StandardName

to see what time zone is coming from where, and log it perhaps?

-Brian
 
Thanks for the reply.
I take it then that there doesn't really seem to be a good reason why it
would be converting the time to the different time zone.

--
Melissa Whalen, Programmer/Analyst
AIT, BBA/IS


| We have some similar stuff.....we ended up going to UTC....
|
| meh
| | > I'm not sure where to post this question. It's kind of strange.
| >
| > We have software on client machines that takes info and sends it to our
| > server (to an SQL Server 2000 database) through a web service.
| > The client machines are all across the US, different time zones and
such.
| > Our server is in the Pacific time zone.
| > When the date and time are sent into the server, it appears that the
time
| is
| > being converted to PST, so there is a descrepancy between the time the
| user
| > has enter and what is being stored on our server.
| >
| > What's up with that? I've tested by changing the time zone on my
| > development machine and the first couple of tries did the same and
| reported
| > different times, but when I stepped throught the Web Service, it stopped
| > doing it - the time was stored as entered in the software.
| >
| > To re-iterate:
| > There are three phases: client enters data into the software --> data is
| > sent to the Web Service --> the web service moves the data to the SQL
| Server
| > 2000 database.
| > As far as I can see it's happening in the code, but I don't really see
why
| > it would matter at all what time zone the data came from.
| >
| > I just thought I'd put this question out to see if anyone had
encountered
| a
| > similar situation.
| >
| > --
| > Melissa Whalen, Programmer/Analyst
| > AIT, BBA/IS
| >
| >
| >
|
|
 
Back
Top