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

Creating Tables in SQL

Revision
5. Date and time data types - revision

Instruction

Good! Do you remember the types connected with date and time that you've learned?

You've learned DATE, TIME and DATETIME also known as TIMESTAMP, which is a combination of the two.

Exercise

The local university wants us to create a table with the dates of exams during the examination period.

Let's create a table called exam with the following colums:

  • exam_id (integer number),
  • lecture_id (integer number) and
  • date_time (a column with both the date and the exact time).

Stuck? Here's a hint!

Type

CREATE TABLE exam (
   exam_id int,
   lecture_id int,
   date_time timestamp
);