MySQL has the function Now() which is a Datetime type field which shows the current date as well as the time.
What is the equivalent of MySQL’s Now() function in SQL Server ?
In SQL Server , you can use the GetDate() function to achieve the same.
SELECT GETDATE() as CurrentDateTime
