DataDesk
All topics
Date functions — practice · DataDesk
DataDesk
How it works
Scenarios
Practice
For trainers
Pricing
Log in
Start free
SQL
Date functions
Extract parts, truncate, add and subtract dates.
0
/ 20 solved
All levels
Basic (6)
Intermediate (7)
Advanced (7)
All
To do
Solved
1
Extract the year
Basic
2
Orders in a month
Basic
3
Month name
Basic
4
Days between dates
Basic
5
Add days
Basic
6
Format a date
Basic
7
Orders per month
Intermediate
8
Weekday vs weekend
Intermediate
9
Quarterly revenue
Intermediate
10
Age from date of birth
Intermediate
11
Signups per year-month
Intermediate
12
Days to pay
Intermediate
13
Last day of the month
Intermediate
14
Month-over-month growth
Interview
Advanced
15
Days between orders
Advanced
16
Active in last 90 days
Advanced
17
Longest gap between logins
Advanced
18
Busiest weekday
Advanced
19
Fiscal year
Interview
Advanced
20
Login streaks
Interview
Advanced