JobPrax
SQL Date functions — practice questions · JobPrax
JobPrax
Practice
Live projects
Guided projects
For colleges
Pricing
Log in
Start free
All SQL topics
SQL
Date functions
Extract parts, truncate, add and subtract dates.
Your progress
0
/ 40
Start the first question
All levels
Basic (26)
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
Year of joining
Basic
8
Order month
Basic
9
March orders
Basic
10
Joined in 2024
Basic
11
June joiners
Basic
12
Project length
Basic
13
Return window
Basic
14
Orders per month
Basic
15
Day of the week
Basic
16
Born in 2008
Basic
17
Days late
Basic
18
Paid on time
Basic
19
Signups in 2023 by month
Basic
20
Start of the month
Basic
21
First week users
Basic
22
February transactions
Basic
23
Which quarter?
Basic
24
Indian date format
Basic
25
Projects started in 2024
Basic
26
Weekend orders
Basic
27
Orders per month
Intermediate
28
Weekday vs weekend
Intermediate
29
Quarterly revenue
Intermediate
30
Age from date of birth
Intermediate
31
Signups per year-month
Intermediate
32
Days to pay
Intermediate
33
Last day of the month
Intermediate
34
Month-over-month growth
Interview
Advanced
35
Days between orders
Advanced
36
Active in last 90 days
Advanced
37
Longest gap between logins
Advanced
38
Busiest weekday
Advanced
39
Fiscal year
Interview
Advanced
40
Login streaks
Interview
Advanced