Which punctuation character can be used as the delimiter between MySQL time parts?

As in the case of date values, MySQL also permits us to use a relaxed format for time. We can use any punctuation character between time parts as a delimiter. Some examples are as follows −

mysql> Select timestamp('2017-10-20 04+05+36'); +----------------------------------+ | timestamp('2017-10-20 04+05+36') | +----------------------------------+ | 2017-10-20 04:05:36              | +----------------------------------+ 1 row in set (0.00 sec) mysql> Select timestamp('2017-10-20 04*05*36'); +----------------------------------+ | timestamp('2017-10-20 04*05*36') | +----------------------------------+ | 2017-10-20 04:05:36              | +----------------------------------+ 1 row in set (0.00 sec) mysql> Select timestamp('2017-10&20 04@05+36'); +----------------------------------+ | timestamp('2017-10&20 04@05+36') | +----------------------------------+ | 2017-10-20 04:05:36              | +----------------------------------+ 1 row in set (0.00 sec) mysql> Select timestamp('2017*10@20 04*05*36'); +----------------------------------+ | timestamp('2017*10@20 04*05*36') | +----------------------------------+ | 2017-10-20 04:05:36              | +----------------------------------+ 1 row in set (0.00 sec)