Question

Single row or scalar functions are applied on a single value and return a single value.
Which of the following is NOT a Date Function?

• A. DATE()
• B. NOW()
• C. THEN()
• D. DAY()

Hint:

In SQL, date functions are used to perform operations on date values, such as extracting the year, month, or day, or getting the current date or time.

Answer 1

The Correct Option is C

DATE(), NOW(), and DAY() are all valid Date Functions used in SQL. `DATE()` returns the current date, `NOW()` returns the current date and time, and `DAY()` extracts the day from a given date. However, `THEN()` is not a valid date function in SQL; it is typically used in `CASE` statements.
Therefore, the correct answer is "THEN()".