MySQL Time Functions

How to work Time Function in MySql:

Code:

SELECT CURRENT_TIME();

SELECT CURTIME();

SELECT CURRENT_TIMESTAMP();

SELECT LOCALTIME();

SELECT LOCALTIMESTAMP();

SELECT TIME("2019-06-15 13:15:20") AS Time;

SELECT HOUR("2019-06-15 13:15:20") AS Time;

SELECT MINUTE("2019-06-15 13:15:20") AS Time;

SELECT SECOND("2019-06-15 13:15:20") AS Time;

SELECT MICROSECOND("2019-06-15 13:15:20") AS Time;

SELECT TIMEDIFF("18:10:11","13:15:20") AS Time;

SELECT TIMEDIFF("14:10:11","13:15:20") AS Time;

SELECT ADDTIME("2019-06-15 05:30:20.000001","5:5.000003") AS Time;

SELECT ADDTIME("2019-06-15 05:30:20.000001","2:10:5.000003") AS Time;

SELECT ADDTIME("2019-06-15 05:30:20.000001","5 2:10:5.000003") AS Time;

SELECT SUBTIME("2019-06-15 05:30:20.000001","5 2:10:5.000003") AS Time;

SELECT MAKETIME(16,15,20) AS Time;

SELECT TIMESTAMP("2019-06-15","13:15:20") AS Time;

SELECT TIME_FORMAT("13:15:20","%H") AS Time;

SELECT TIME_FORMAT("13:15:20","%H %i %s") AS Time;

SELECT TIME_FORMAT("13:15:20","%H-%i-%s") AS Time;

SELECT TIME_FORMAT("13:15:20","%H-%i-%s %p") AS Time;

SELECT SEC_TO_TIME("1") AS Time;

SELECT SEC_TO_TIME("5454") AS Time;