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 Azure. Click here to read the blog article.