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

Data Types in SQL

Introduction
Final Quiz
5. Question 4
Summary

Instruction

Well done! How about datetime columns?

Exercise

The local university wants us to create a table to store exam dates.

Let's make a table called exam with the following columns:

  1. exam_id – An integer number and the primary key, generated automatically by default.
  2. lecture_id – An integer number.
  3. date_time – A column with the exact date and time.