How can I use any character, at the place of space, in MySQL TIMESTAMP to distinguish between date and time parts?

MySQLMySQLi Database

We can use the only character ‘T’ (in Capital form only) at the place of space between date and time part. It can be elucidated with the help of the following example −

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)
raja
Published on 19-Feb-2018 10:42:47
Advertisements