Here's an interesting problem.

I host an app with customers all around the world. Every now and then, the
tables need to be reorganised. In a normal local system, you'd just do it at a
particular time but because of timezones, the app would have to do it at a time
suitable to the customer's processes.

The simple thing for me to do would be to tell the client to inform me of his
desired time in terms of my time zone (which currently is not subject to
daylight saving).

Being more customer focussed (sez he), I'd rather have the customers inform me,
in terms of their time zones, when it should be run.

I'd expect the time info to be stored in a table with columsn clientNo,
date_from,date_to,UTC (with as many rows as needed for each customer). The input
data would be validated to ensure that there is coverage for the full year.

Is there a better way?

tia
regards - anthony shipley

look, ma - no .sig