Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 63 of 81

MySQL Functions — Question 14

Back to all questions
14
Question

Question 7

Write SQL statement to display

Today, the date is <current date>
Answer 
SELECT CONCAT('Today, the date is ', CURDATE()) AS CURDATE;
Output
+-------------------------------+
| CURDATE                       |
+-------------------------------+
| Today, the date is 2024-05-20 |
+-------------------------------+