Suppose user A uses a form to invite User B for a chat tomorrow at noon. But UserB is a different time zone. And the hosted SQL server is on a computer in yet a third time zone.
One possibility is:
The user submits the time he wants to chat, and it is stored in the database. The database compares that time with 'getdate()' to figure out the timezone difference, if any, between the user and the server. This might get tricky if there was a time lag,
for instance the user submits at 9:59.999 seconds, and the sql server stored at 10:01, but I'm sure that is solvable. But the question then is, if my webserver sends a date to the recipient, how can it possibly know what date to use?
Go to the complete details ...