MCQ King
SQLite – Date and Time Functions
1 / 24
1. Which function in SQLite returns the current date and time in the ‘YYYY-MM-DD HH:MM:SS’ format?
2 / 24
2. What is the purpose of the DATE() function in SQLite?
3 / 24
3. In SQLite, how can you extract the year from a date using a function?
4 / 24
4. Which function in SQLite is used to add or subtract a specified number of days from a date?
5 / 24
5. What is the purpose of the TIME() function in SQLite?
6 / 24
6. In SQLite, how can you extract the month from a date using a function?
7 / 24
7. Which function in SQLite returns the current date in ‘YYYY-MM-DD’ format?
8 / 24
8. What is the purpose of the DATETIME() function in SQLite?
9 / 24
9. In SQLite, how can you extract the day of the week (0-6) from a date using a function?
10 / 24
10. Which function in SQLite is used to add or subtract a specified number of months from a date?
11 / 24
11. What is the purpose of the strftime() function in SQLite?
12 / 24
12. In SQLite, how can you extract the hour from a time using a function?
13 / 24
13. Which function in SQLite is used to add or subtract a specified number of hours from a time?
14 / 24
14. What is the purpose of the DATE_PART() function in SQLite?
15 / 24
15. In SQLite, how can you extract the minute from a time using a function?
16 / 24
16. Which function in SQLite is used to add or subtract a specified number of minutes from a time?
17 / 24
17. What is the purpose of the DATE_DIFF() function in SQLite?
18 / 24
18. In SQLite, how can you extract the second from a time using a function?
19 / 24
19. Which function in SQLite is used to add or subtract a specified number of seconds from a time?
20 / 24
20. What is the purpose of the STRFTIME() function in SQLite?
21 / 24
21. In SQLite, how can you extract the timezone offset from a time using a function?
22 / 24
22. What is the purpose of the CURRENT_TIME() function in SQLite?
23 / 24
23. In SQLite, how can you extract the timezone name from a time using a function?
24 / 24
24. Which function in SQLite is used to add or subtract a specified number of years from a date?
Your score is
Restart quiz