There are many occasions when you will want to obtain the current date and time from a Microsoft SQL Server instance. Possibly the most common of these is when auditing the time of a database operation, using either the local or the UTC date and time.
...
Go to the complete details ...