SQLSERVER : To show current datetime

3 ways to get current datetime in sql:

select Getdate()
select Current_timestamp
select {fn now()}