Why date handling is essential in MySQL - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select all records where the date is exactly '2024-06-01'.

MySQL

SELECT * FROM events WHERE event_date = '[1]';

Drag options to blanks, or click blank then click option'

A2024-06-01

B06-01-2024

C2024/06/01

DJune 1, 2024

Attempts:

3 left

💡 Hint

Common Mistakes

Using non-standard date formats like '06-01-2024' or 'June 1, 2024' causes no matches.

The date format 'YYYY-MM-DD' is the standard for MySQL date comparisons.

2fill in blank

medium

Complete the code to find all records where the date is after '2024-01-01'.

MySQL

SELECT * FROM orders WHERE order_date [1] '2024-01-01';

Drag options to blanks, or click blank then click option'

A=

B<

C>

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' or '<=' will select dates before or on the given date, not after.

The '>' operator selects dates after the given date.

3fill in blank

hard

Fix the error in the query to select records where the date is between '2024-01-01' and '2024-06-01'.

MySQL

SELECT * FROM sales WHERE sale_date [1] '2024-01-01' AND sale_date [2] '2024-06-01';

Drag options to blanks, or click blank then click option'

A>=

B<

C<=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '>' or '<' excludes the boundary dates from the results.

Use '>=' for the start date and '<=' for the end date to include both dates in the range.

4fill in blank

hard

Fill both blanks to select records where the date is in June 2024 using the BETWEEN operator.

MySQL

SELECT * FROM appointments WHERE appointment_date BETWEEN '[1]' AND '[2]';

Drag options to blanks, or click blank then click option'

A2024-06-01

B2024-05-31

C2024-06-30

D2024-07-01

Attempts:

3 left

💡 Hint

Common Mistakes

Using dates outside June will include unwanted records.

The BETWEEN operator includes the start and end dates, so use June 1 and June 30.

5fill in blank

hard

Fill all three blanks to select records where the date is in 2024 and the month is June.

MySQL

SELECT * FROM meetings WHERE YEAR(meeting_date) = [1] AND MONTH(meeting_date) = [2] AND DAY(meeting_date) [3] 15;

Drag options to blanks, or click blank then click option'

A2024

B6

C>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong month number or wrong comparison operator for the day.

We check the year is 2024, month is 6 (June), and day is greater than 15.