How to differentiate date and time parts using arbitrary characters at spaces in MySQL TIMESTAMP?

We can use the only character "T" (uppercase only) for the space between the date and time parts. This can be clarified with the help of the following examples -

mysql> Select TIMESTAMP('2017-10-20T06:10:36');
+----------------------------------+
| TIMESTAMP('2017-10-20T06:10:36') |
+----------------------------------+
| 2017-10-20 06:10:36              |
+----------------------------------+
1 row in set (0.00 sec)

The above is the detailed content of How to differentiate date and time parts using arbitrary characters at spaces in MySQL TIMESTAMP?. For more information, please follow other related articles on the PHP Chinese website!