Is there any framework or API function i can use to get the date and time of
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.
