I am working on the design of an application that will be developed in Java. The developer wants to use the 'milliseconds since 1970' method to represent timestamps.

The customer is in Europe. The issue is that Sommerzeit (German daylight savings time) is a week different than daylight savings time in the U.S.

I want to find a way to make the design without two datetime fields, but track the entry of data consistently.

Any ideas?

Thanks in advance.