This content was proof-read by Grammarly. You can Try Grammary for FREE
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