• I forgot to mention one thing. The Oracle function SYS_EXTRACT_UTC that you mention is exactly what we would need in SQL Server to solve this problem easily. And from what I understand, this and other time functions will be included in next version of SQL Server.

    --

    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/