Question

Consider the following SQL functions:
(A) CURDATE()
(B) CURRENT DATE()
(C) CURRENT DATE
(D) TODAY()

• A. (A), (B), and (D) only
• B. (A), (B), and (C) only
• C. (A), (B), (C), and (D)
• D. (B), (C), and (D) only

Answer 1

The Correct Option is B

Database management systems (DBMS) exhibit variations in their implementation of date functions. Let's examine the provided functions:

• (A) CURDATE(): A MySQL-specific function that returns the current date in 'YYYY-MM-DD' format. It is widely supported within MySQL environments.
• (B) CURRENT DATE(): This syntax appears erroneous, as SQL functions containing spaces typically omit parentheses. However, CURRENT DATE, without parentheses, is a valid function in DB2, Oracle, and other SQL databases for retrieving the current date.
• (C) CURRENT DATE: This is a standard SQL function, compatible with many databases including DB2 and PostgreSQL, which retrieves the current date without requiring parentheses.
• (D) TODAY(): This is not a standard SQL function and is absent in prominent databases such as MySQL, PostgreSQL, and SQL Server.

Considering typical implementations and SQL standards, both (A) and (C) are recognized for providing the current date. While (B) may be considered syntactically incorrect due to the inclusion of parentheses, a broader interpretation or correction would align it with (C). Therefore, the set of correct answers includes:

• (A) CURDATE()
• (B) CURRENT DATE() (interpreted as CURRENT DATE)
• (C) CURRENT DATE

Based on the standard usage and interpretation across various DBMS, the correct selection is:

(A), (B), and (C) only