$1.$ Which function is used to return the current date and time in SQL Server?

A$)$ NOW$()$

B$)$ CURRENT$\_$TIMESTAMP

C$)$ GETDATE$()$

D$)$ TIMEDATE$()$