MySQL/30.MySQL Time Functions.txt at master · Emran-Bu/MySQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
SELECT CURRENT_TIME();
SELECT CUR_TIME();
SELECT CURRENT_TIMESTAMP();
SELECT LOCALTIME();
SELECT LOCALTIMESTAMP();

SELECT TIME("2021-07-07 02:30:20") AS TIME;
SELECT HOUR("2021-07-07 02:30:20") AS TIME;
SELECT SECOND("2021-07-07 02:30:20") AS TIME;
SELECT MINUTE("2021-07-07 02:30:20") AS TIME;

SELECT TIMEDIFF("02:30:20", "08:30:20") AS TIME;

SELECT ADDTIME("2021-07-07 02:30:20", "5:20") AS TIME;
SELECT ADDTIME("2021-07-07 02:30:20", "01:30:20") AS TIME;
SELECT ADDTIME("2021-07-07 02:30:20", "5 01:30:20") AS TIME;

SELECT SUBTIME("2021-07-07 02:30:20", "5:20") AS TIME;
SELECT SUBTIME("2021-07-07 02:30:20", "01:30:20") AS TIME;
SELECT SUBTIME("2021-07-07 02:30:20", "5 01:30:20") AS TIME;

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

SELECT TIMESTAMP("2021-07-07", "01:30:20") AS TIME;

SELECT TIME_FORMAT("02:30:20", "%H%i%s") AS TIME;
SELECT TIME_FORMAT("02:30:20", "%H-%i-%s %p") AS TIME;

SELECT TIME_TO_SEC("02:30:20") AS TIME;
SELECT SEC_TO_TIME("5454") AS TIME;