Informatics Practices

Write commands to display the system date.

SQL Queries

1 Like

Answer

SELECT SYSDATE();

Output

+---------------------+
| SYSDATE()           |
+---------------------+
| 2024-06-14 11:56:41 |
+---------------------+

Answered By

2 Likes

Related Questions

Consider the table "Item" given below and give the outputs on the basis of it:
Table: ITEM
Itemno Iname Price (₹) Quantity
101 Soap 50 100
102 Powder 100 50
103 Facecream 150 25
104 Pen 50 200
105 Soapbox 20 100
(a) SELECT SUM(Price) FROM ITEM;
(b) SELECT AVG(Price) FROM ITEM;
(c) SELECT MIN(Price) FROM ITEM;
(d) SELECT MAX(Price) FROM ITEM;
(e) SELECT COUNT(Price) FROM ITEM;
(f) SELECT DISTINCT Price FROM ITEM;
(g) SELECT COUNT(DISTINCT Price) FROM ITEM;
(h) SELECT Iname, Price*Quantity FROM ITEM;
View Answer