Ravindra BagaleCourses & study guides Track your progress

Date and Time Queries for Analysts

By Last updated:

Lessons in this chapter:

  1. 9.1 How to Filter a Date Range the Safe Way (>= Start AND < Next)
  2. 9.2 How to Extract Year, Month and Day in SQLite with strftime()
  3. 9.3 How to Compute Date Differences (Cheque Clearing Delay Story)
  4. 9.4 Why a Function on a Date Column Can Be Slow Later (Habit for Bigger Databases)
  5. 9.5 Practice: Monthly Totals and Late Cheque Clearing

Quiz for this chapter is available on the Learn tracker after deploy.

Ravindra Bagale's Tip

Finish every lesson example in DB Browser before the quiz.

Ravi Sir's Cards for this chapter

Date ranges the safe way. Monthly reports must include every row from the last day of the month, even the late evening ones.Revision cardWhy is BETWEEN risky for date ranges? SQLite compares the dates as text, and '2026-09-30 15:30:00' sorts after '2026-09-30'. So BETWEEN with a bare end date leaInterview cardstrftime() vs julianday(). strftime() takes a part out of a date, such as the year or month. julianday() turns a date into a day number.Comparison card

All cards for this chapter