Informatics Practices
Write command to print the day of the week of your Birthday in the year 1999.
SQL Queries
2 Likes
Answer
SELECT DAYOFWEEK('1999-07-21');
Output
+-------------------------+
| DAYOFWEEK('1999-07-21') |
+-------------------------+
| 4 |
+-------------------------+
Answered By
3 Likes
Related Questions
Write a command to display the name of current month.
Write SQL statement to display
Today, the date is <current date>Write a command to display the current time.
Consider two fields Bdate, which stores the birth date and Jdate, which stores the joining date of an employee. Write commands to find out and display the approximate age of an employee as on today.