I think the best solution would be to save all datetimes in utc-time. Then you could convert to whichever time zone / format you want for presenting it. Unfortunately though SQL Server does not have all the functions that is needed for this, but I am sure Antares has something up his sleeve.

--

Chris Hedgate @ Extralives (http://www.extralives.com/)

Contributor to Best of SQL Server Central 2002 (http://www.sqlservercentral.com/bestof/)

Articles: http://www.sqlservercentral.com/columnists/chedgate/