How to Get the Current date in SQL server ?

To get the current date and time in SQL server,use the following syntax.

Syntax:

Getdate()

Example:

Select Getdate()

Output:

2016-04-16 12:09:52.613

Now the SQL server installed system data and time will be displayed.