Question

______________ function  returns current date and time.

(a) SET DATEFIRST

(b) SYSDATETIME

(c) Cert_ID

(d) GETDATE

The question was asked by my college professor while I was bunking the class.

The query is from Builtin Functions in section Laying the Foundation of SQL Server

Answer 1

The correct option is (d) GETDATE

The explanation is: GETDATE function is used to obtain the current system date and time. Although GETDATE doesn’t have any input parameters, you still need to include the parentheses in your code because that’s how SQL Server typically identifies functions.