<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
We finally have to deal with time zones. We use the server
date-time everywhere, rather than relying on workstation
date-times. This is not an interactive forum type application where
the flow of data is merged from various timezones. It is a business
management system with appointments and bills etc. The timestamps
of these records have to remain as created. But they can not come
from the workstation clock.<br>
<br>
Going forward, a database server could be servicing workstations in
different time zones.<br>
<br>
I am considering<br>
<br>
<ol>
<li>Set the server time as UTC</li>
<li>Keep a table for time zone versus branch (how do I keep this
upto date at daylight saving boundaries)</li>
<li>Use the utc + timezone difference to stamp each bill or
appointment made for each branch.<br>
</li>
</ol>
How is everyone else handling it ?<br>
<br>
Regards<br>
<br>
Rohit<br>
</body>
</html>