与日期值的情况一样，MySQL 也允许我们使用宽松的时间格式。我们可以在时间部分之间使用任何标点符号作为分隔符。一些示例如下 -
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)
以上是哪个标点符号可以用作 MySQL 时间部分之间的分隔符？的详细内容。更多信息请关注PHP中文网其他相关文章！
