Beginner

109. TIME Data Type

Learn how SQL stores time-of-day information.

📘 Lesson 109 of 728 ⏱ 8 min 🎯 Beginner

The TIME data type is used by supported database systems to represent time-of-day information such as hours, minutes, seconds, and potentially fractional seconds.

Some business processes depend not only on the date but also on the exact time an event occurred.

A customer-support system may store the time at which a service request was created.

SQL 
SELECT
    StartTime,
    EndTime
FROM WorkSchedule;

TIME values are useful for transaction times, service requests, operational schedules, attendance systems, and event tracking.

  • TIME represents time-of-day information.
  • It can include hours, minutes, and seconds.
  • Some systems support fractional seconds.
  • TIME differs from DATE.
  • Exact TIME features vary by database system.
What does TIME store?

TIME stores time-of-day information such as hours, minutes, and seconds.

What is the difference between DATE and TIME?

DATE represents a calendar date, while TIME represents a time of day.

Have you finished this lesson?

Introduction to SQL – All Lessons