Informatics Practices
Write a command to display the current time.
SQL Queries
1 Like
Answer
SELECT TIME(NOW());
Output
+-------------+
| TIME(NOW()) |
+-------------+
| 15:40:57 |
+-------------+
Answered By
2 Likes
Related Questions
Write SQL statement to display
Today, the date is <current date>Write command to print the day of the week of your Birthday in the year 1999.
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.
Find the output of the following SQL Query :
SELECT ROUND(7658.345, 2);