Time zone problem

[Ishan Bhalla]

Hello everyone,

Is there any framework or API function i can use to get the date and time of
any city in the world?

Basically our server is based in Sydney and we need to know time in Perth
when any scanning information comes from there. The server time is always
Sydney time.

Thanks in advance
Ishan

[PIEBALD]

> Is there any framework or API function i can use to get the date and time of

any city in the world?
I just took a quick look and didn't see any. I'm not surprised, I doubt the
information would be something that could be "shipped", but rather would have
to be pulled real-time (as it were). Some server somewhere would need to
offer a web service or some such for that purpose.

However, take a look at:
http://www.codeproject.com/dotnet/WorldClock.asp
Basically our server is based in Sydney and we need to know time in Perth
when any scanning information comes from there. The server time is always
Sydney time.

Unless the sender isn't timestamping the data there should be no problem.
You should only need to know _when_ the event occurred regardless of _where_
it occurrred. If you _do_ need to know where, then again, the sender should
tell you and you can store that seperately.

A related issue came up several years ago when the employer for whom I was
working at the time was changing from Oracle to SQL Server 7. It became
apparent that confusion could occur when the client was in a different time
zone from the server. The solution was for the client code to query the
database for what time to use rather than the client's time.

[clintonG]

This [1] is interesting. Also check out "Internet Time" [2] a very
compelling idea.

No pun intended, but its "time" software developers formed a coalition to
solve this problem which would be easy given the funding -- a business
model -- to pay for a server farm to host and support localized web service
applications.

<%= Clinton Gallagher
METROmilwaukee (sm) "A Regional Information Service"
NET csgallagher AT metromilwaukee.com
URL http://metromilwaukee.com/
URL http://clintongallagher.metromilwaukee.com/

[1] http://www.timeanddate.com/worldclock/
[2] http://www.timeanddate.com/time/internettime.html

"PIEBALD" <PI*****@discussions.microsoft.com> wrote in message
news:F8**********************************@microsof t.com...

Is there any framework or API function i can use to get the date and time
of
any city in the world?

I just took a quick look and didn't see any. I'm not surprised, I doubt
the
information would be something that could be "shipped", but rather would
have
to be pulled real-time (as it were). Some server somewhere would need to
offer a web service or some such for that purpose.

However, take a look at:
http://www.codeproject.com/dotnet/WorldClock.asp

Basically our server is based in Sydney and we need to know time in Perth
when any scanning information comes from there. The server time is always
Sydney time.

Unless the sender isn't timestamping the data there should be no problem.
You should only need to know _when_ the event occurred regardless of
_where_
it occurrred. If you _do_ need to know where, then again, the sender
should
tell you and you can store that seperately.

A related issue came up several years ago when the employer for whom I was
working at the time was changing from Oracle to SQL Server 7. It became
apparent that confusion could occur when the client was in a different
time
zone from the server. The solution was for the client code to query the
database for what time to use rather than the client's time.