Debian Codegraph @

mysql-test/suite/sysschema/r/fn_format_time.result

raw
1 SELECT sys.format_time(NULL);
2 sys.format_time(NULL)
3 NULL
4 SELECT sys.format_time(1);
5 sys.format_time(1)
6 1 ps
7 SELECT sys.format_time(999);
8 sys.format_time(999)
9 999 ps
10 SELECT sys.format_time(1000);
11 sys.format_time(1000)
12 1.00 ns
13 SELECT sys.format_time(999999);
14 sys.format_time(999999)
15 1000.00 ns
16 SELECT sys.format_time(1000000);
17 sys.format_time(1000000)
18 1.00 us
19 SELECT sys.format_time(999999999);
20 sys.format_time(999999999)
21 1000.00 us
22 SELECT sys.format_time(1000000000);
23 sys.format_time(1000000000)
24 1.00 ms
25 SELECT sys.format_time(999999999999);
26 sys.format_time(999999999999)
27 1000.00 ms
28 SELECT sys.format_time(1000000000000);
29 sys.format_time(1000000000000)
30 1.00 s
31 SELECT sys.format_time(59999999999999);
32 sys.format_time(59999999999999)
33 60.00 s
34 SELECT sys.format_time(60000000000000);
35 sys.format_time(60000000000000)
36 1.00 m
37 SELECT sys.format_time(3599999999999999);
38 sys.format_time(3599999999999999)
39 60.00 m
40 SELECT sys.format_time(3600000000000000);
41 sys.format_time(3600000000000000)
42 1.00 h
43 SELECT sys.format_time(86399999999999988);
44 sys.format_time(86399999999999988)
45 24.00 h
46 SELECT sys.format_time(86400000000000000);
47 sys.format_time(86400000000000000)
48 1.00 d
49 SELECT sys.format_time(604799999999999888);
50 sys.format_time(604799999999999888)
51 7.00 d
52 SELECT sys.format_time(604800000000000000);
53 sys.format_time(604800000000000000)
54 1.00 w
55 SELECT sys.format_time(2389472398472389748237429837423984728374);
56 sys.format_time(2389472398472389748237429837423984728374)
57 3950847219696411300000.00 w