Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Standard SQL Functions

Introduction
Dates
Time
Timestamps
Extract functions
Timezone conversion
Intervals
Current date and time
Review

Instruction

Good job. BETWEEN is often used with intervals when we want to find facts for a specific month. We no longer need to check whether a given month has 28, 29 (February), 30 or 31 days, the database will do that for us.

SELECT id
FROM aircraft
WHERE produced BETWEEN '2010-01-01' AND CAST('2010-01-01' AS date) + INTERVAL '1' MONTH;

Check it out for yourself!

Exercise

Count the number of flights performed in August 2015. Name the column flight_no.