SQL Server Uptime, SQL 2008 onwards

SELECT DATEDIFF(day,[sqlserver_start_time],GETDATE()) AS [Days SQL Server Has Been Up]

FROM sys.dm_os_sys_info;