Transact-SQL includes a number of date and time functions that have values are derived from the operating system of the computer on which the instance of SQL Server is running. The MCS UK Solution Development Team blogs about how these work on SQL
Read More...
Read the complete post at http://blogs.msdn.com/b/sqlazure/archive/2010/05/26/10015721.aspx