SQL Date Function
6.Which of these is not a date function?
-
A. MONTH()
-
B. YEAR()
-
C. SUM()
-
D. DATEPART()
SUM()
SUM()
7.What is returned by:
SELECT CURRENT_DATE;
-
A. System time
-
B. Only date
-
C. Full date and time
-
D. NULL
Only date
Only date
8.What does this return?
SELECT DATEDIFF('2024-04-15', '2024-04-01');
-
A. 14
-
B. 15
-
C. 1
-
D. Error
14
14
9.Output of this query?
SELECT EXTRACT(MONTH FROM DATE '2025-06-15');
-
A. 6
-
B. 15
-
C. 2025
-
D. NULL
6
6
10.What is the result of:
SELECT NOW();
-
A. Only date
-
B. Current timestamp (date + time)
-
C. NULL
-
D. System version
Current timestamp (date + time)
Current timestamp (date + time)