Dates and times in SQL
Group a mobile game's signups by month, count days between events with julianday(), and stop timestamps from slipping out of a date range.
- The skill
- Turn timestamps into months, weekdays and gaps in days, and filter date ranges without losing a day.
- You make
- A launch report for a mobile puzzle game: signups per month, days to first purchase, the busiest day of the week.
Premium lesson
£7.99 a month or £59 a year. Cancel any time.
Builds on 33 Final challenge: the film database. Free to try: SQL Foundations and the playground.
Passed
You can now
Step 1 of 9
exercise_1.sql
You've reached the good stuff.
5 exercises in this lesson, checked as you type. Premium opens every lesson after Foundations, in all four courses.
SQLite