How Do You Write Data Type in Time in SQL?


Angela Bailey

In SQL, the data type for storing time values is called TIME. The TIME data type allows you to store time values in a specific format and perform various operations on them.

Defining the TIME Data Type

To define a column with the TIME data type, you need to specify the name of the column and the TIME keyword followed by any additional attributes. Here’s an example:

    id INT,
    event_time TIME

In this example, we create a table called “myTable” with two columns: “id” of type INT and “event_time” of type TIME.

Inserting Time Values

To insert time values into a column of the TIME data type, you can use the INSERT INTO statement. The time value needs to be specified in a specific format: ‘HH:MI:SS’.

INSERT INTO myTable (id, event_time)
VALUES (1, '10:30:00');

This query inserts a row into “myTable” with an ID of 1 and an event_time value of 10:30:00.

Retrieving Time Values

To retrieve time values from a column of the TIME data type, you can use the SELECT statement. You can also format the output using SQL functions like DATE_FORMAT.

SELECT event_time
FROM myTable;

This query retrieves all event_time values from the “myTable” table.

Performing Operations on Time Values

You can perform various operations on time values using SQL functions like ADDTIME, SUBTIME, TIMEDIFF, etc. These functions allow you to add or subtract time from a given value, calculate the difference between two time values, and more.


SELECT ADDTIME(event_time, '01:30:00') AS new_time
FROM myTable;

This query adds 1 hour and 30 minutes to each event_time value in the “myTable” table and returns the result as “new_time”.


The TIME data type in SQL provides a convenient way to store and manipulate time values. By understanding how to define, insert, retrieve, and perform operations on time values, you can effectively work with time-related data in your SQL queries.

Discord Server - Web Server - Private Server - DNS Server - Object-Oriented Programming - Scripting - Data Types - Data Structures

Privacy Policy