SQL, SQL Server, Tutorials, Oracle, PL/SQL, Interview Questions & Answers, Joins, Multiple Choice Questions, Quiz, Stored Procedures, Select, Insert, Update, Delete and other latest topics on SQL, SQL Server and Oracle.
SQL DATEDIFF
Multiple Choice Questions - SQL DATEDIFF
1. What does the DATEDIFF function in SQL return?
A) The number of days between two dates
B) The number of months between two dates
C) The number of years between two dates
D) The difference in time between two dates
2. Which of the following is a valid syntax for the DATEDIFF function in SQL?
A) DATEDIFF(date2 - date1)
B) DATEDIFF(date2, date1)
C) DATEDIFF(date1 - date2)
D) DATEDIFF(date1, date2)
3. If you want to calculate the number of days between '2022-01-01' and '2022-01-15', what would be the correct SQL query?
A) SELECT DATEDIFF('2022-01-01' - '2022-01-15')
B) SELECT DATEDIFF('2022-01-15', '2022-01-01')
C) SELECT DATEDIFF('2022-01-01', '2022-01-15')
D) SELECT DATEDIFF('2022-01-15' - '2022-01-01')
4. What would be the result of the following SQL query: SELECT DATEDIFF('2022-01-01', '2022-01-31')?
A) 30
B) 31
C) 29
D) 1
5. If you want to calculate the number of months between '2022-01-01' and '2022-06-01', what would be the correct SQL query?
A) SELECT DATEDIFF('2022-06-01', '2022-01-01', 'month')
B) SELECT DATEDIFF('2022-01-01', '2022-06-01', 'month')
C) SELECT DATEDIFF('2022-01-01' - '2022-06-01', 'month')
D) SELECT DATEDIFF('2022-06-01' - '2022-01-01', 'month')
6. What would be the result of the following SQL query: SELECT DATEDIFF('2022-01-01', '2022-02-01')?
A) 31
B) 30
C) 29
D) 1
7. If you want to calculate the number of years between '2022-01-01' and '2032-01-01', what would be the correct SQL query?
A) SELECT DATEDIFF('2022-01-01', '2032-01-01', 'year')
B) SELECT DATEDIFF('2032-01-01', '2022-01-01', 'year')
C) SELECT DATEDIFF('2022-01-01' - '2032-01-01', 'year')
D) SELECT DATEDIFF('2032-01-01' - '2022-01-01', 'year')
8. What would be the result of the following SQL query: SELECT DATEDIFF('2022-01-01', '2022-12-31')?
A) 364
B) 365
C) 366
D) 367
9. If you want to calculate the number of quarters between '2022-01-01' and '2022-09-01', what would be the correct SQL query?
A) SELECT DATEDIFF('2022-01-01', '2022-09-01', 'quarter')
B) SELECT DATEDIFF('2022-09-01', '2022-01-01', 'quarter')
C) SELECT DATEDIFF('2022-01-01' - '2022-09-01', 'quarter')
D) SELECT DATEDIFF('2022-09-01' - '2022-01-01', 'quarter')
10. What would be the result of the following SQL query: SELECT DATEDIFF('2022-01-01', '2023-01-01')?
A) 365
B) 366
C) 367
D) 368
Answers