/* 036- Time Functions */ 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;