Copyright

SQL Data Types: DATE, TIME & TIMESTAMP

Instructions:

Choose an answer and hit 'next'. You will receive your score and answers at the end.

question 1 of 3

What is the correct format for TIME?

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 79,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.

Try it risk-free
Try it risk-free for 30 days. Cancel anytime
Already registered? Log in here for access

1. Which shows how the column 'game_time' should be formatted using TIME, assuming it is not the last column in a database?

2. What is the proper format for DATE?

Create your account to access this entire worksheet
A Premium account gives you access to all lesson, practice exams, quizzes & worksheets
Access to all video lessons
Quizzes, practice exams & worksheets
Certificate of Completion
Access to instructors
Create an account to get started Create Account

About This Quiz & Worksheet

For this quiz and worksheet combo, you will be looking at time periods used in SQL. Questions focus on the correct format for TIME as well as the place where you should not use a TIMESTAMP.

Quiz & Worksheet Goals

You can expect the subjects below to appear in the quiz:

  • How the 'game_time' column should be formatted
  • The proper format for DATE
  • Formatting DATE for 'enrollment_date'
  • Where not to use a TIMESTAMP

Skills Practiced

  • Information recall - remember what you have learned about the proper format for DATE
  • Defining key concepts - ensure that you know the correct format for TIME
  • Knowledge application - use what you know to answer questions about where not to use a TIMESTAMP

Additional Learning

To practice more with the language, head to the lesson titled, SQL Data Types: DATE, TIME & TIMESTAMP. It includes the topics mentioned below:

  • Why you might use a specific data type
  • Where to properly use TIMESTAMP
  • SQL queries
Support