[DUG] Timezones for Bills and things

[Rohit Gupta]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20161124/6c0e099b/attachment.html