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.
Going forward, a database server could be servicing workstations in
different time zones.
I am considering
1. Set the server time as UTC
2. Keep a table for time zone versus branch (how do I keep this upto
date at daylight saving boundaries)
3. Use the utc + timezone difference to stamp each bill or appointment
made for each branch.
How is everyone else handling it ?
Regards
Rohit
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: [email protected]
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [email protected] with
Subject: unsubscribe
