Which of the following data function in SQL returns the current database…

2024

Which of the following data function in SQL returns the current database system timestamp as a ‘date time’ value without the database time zone offset?

  1. A.

    GETTIME

  2. B.

    GETDATE

  3. C.

    CASTDATE

  4. D.

    CASTTIME

Attempted by 142 students.

Show answer & explanation

Correct answer: B

In SQL Server, `GETDATE()` returns the current database system timestamp as a datetime value without a time-zone offset.

Explore the full course: Up Lt Grade Assistant Teacher 2025