Returning SQL Datetime from SQL Server

I love this stored procedure - it allows us to get the Date Time from the SQL server - this prevents us from relying or "trusting" the local workstation's date time.

Great for security, logging and time tracking applications.

CREATE PROCEDURE map_GetDateTimeFromSQLServer
AS
SELECT GETDATE() AS tDateTime
GO