XPost: microsoft.public.sqlserver.programming   
   From: papajoe.nospam@nospam.net   
      
   Iain   
      
   >   
   > Is there a feature I can use in SQL server 2005 which can apply the   
   > offset during insert update and select based on the database user   
   > log-in? (i.e. so that the dates are stored in GMT but as far as that   
   > database user is concerned they will be in USA(EST)?)   
   >   
      
   I am not sure I totally understand, but what about:   
      
   SELECT DATEDIFF(hh, GetUTCDate(), GETDATE());   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)