#1

column_name TIME;

#2

start_at TIME;

#3

column_name TIME(N);

#4

begin_at TIME(3);

#5

CREATE TABLE tests (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL,
    start_at TIME,
    end_at TIME
);

#6

INSERT INTO tests(name,start_at,end_at)
VALUES('Test 1', '08:00:00','10:00:00');

#7

SELECT 
    name, start_at, end_at
FROM
    tests;

#8

INSERT INTO tests(name,start_at,end_at)
VALUES('Test 2','083000','101500');

#9

INSERT INTO tests(name,start_at,end_at)
VALUES('Test invalid','083000','108000');

#10

INSERT INTO tests(name,start_at,end_at)
VALUES('Test 3',082000,102000);

#11

INSERT INTO tests(name,start_at,end_at)
VALUES('Test 4','9:5:0',100500);

#12

SELECT 
    CURRENT_TIME() AS string_now,
    CURRENT_TIME() + 0 AS numeric_now;

#13

SELECT 
    CURRENT_TIME(),
    ADDTIME(CURRENT_TIME(), 023000),	
    SUBTIME(CURRENT_TIME(), 023000);

#14

SELECT 
    TIMEDIFF(end_at, start_at)
FROM
    tests;

#15

SELECT 
    name,
    TIME_FORMAT(start_at, '%h:%i %p') start_at,
    TIME_FORMAT(end_at, '%h:%i %p') end_at
FROM
    tests;

#16

SELECT 
   CURRENT_TIME(), 
   UTC_TIME();