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

The SQL functions that return the current date are (A) CURDATE(), (B) CURRENT_DATE(), and (C) CURRENT_DATE.

Additional Context:

• Valid Date Functions:
  • CURDATE() (A): MySQL function returning current date
  • CURRENT_DATE() (B): MySQL/SQL standard function (parentheses optional)
  • CURRENT_DATE (C): SQL standard (no parentheses)
• About TODAY() (D):
  • Not a standard SQL function
  • Used in spreadsheet applications (Excel)
• Database Compatibility:
  • MySQL/MariaDB: Supports all three valid functions
  • PostgreSQL: Uses CURRENT_DATE
  • SQL Server: GETDATE() or CURRENT_TIMESTAMP
• Usage Example:

  SELECT CURDATE(), CURRENT_DATE(), CURRENT_DATE;
  -- Returns: 2023-11-15 | 2023-11-15 | 2023-11-15
      

Correct Answer: (2) (A), (B) and (C) only.