What MySQL returns on using any other character than ‘T’ or ‘Space’ between date and time parts?

In that case, MySQL will return all zeros at the place of time along with correct date part. An example is as follows in which we used character ‘W’ at the place of ‘T’ or ‘Space’ between date and time part −

mysql> Select TIMESTAMP('2017-10-20W06:10:36');
+----------------------------------+
| TIMESTAMP('2017-10-20W06:10:36') |
+----------------------------------+
| 2017-10-20 00:00:00              |
+----------------------------------+
1 row in set, 1 warning (0.00 sec)

Usharani

Published on 19-Feb-2018 10:43:27

• Related Questions & Answers
• What is the use of ‘ALL’, ‘ANY’, ’SOME’, ’IN’ operators with MySQL subquery?
• Validate input: replace all ‘a’ with ‘@’ and ‘i’ with ‘!’JavaScript
• Why in MySQL, we cannot use arithmetic operators like ‘=’, ‘<’ or ‘<>’ with NULL?
• Are ‘this’ and ‘super’ keywords in Java?
• ‘AND’ vs ‘&&’ operators in PHP
• What is the benefit of MySQL ‘IS NULL’ and ‘IS NOT NULL’?
• Comparing ‘cubic’ and ‘linear’ 1-D interpolation using SciPy library
• How can we create MySQL stored procedures without ‘BEGIN’ and ‘END’?
• What MySQL returns if I do not use the keyword ‘RIGHT’ or ‘LEFT’ while writing the query for RIGHT JOIN or LEFT JOIN?
• Rearrange an array such that ‘arr[j]’ becomes ‘i’ if ‘arr[i]’ is ‘j’ in C++
• Learn Why ‘less’ is Faster Than ‘more’ Command for Effective File Navigation
• Find all the names beginning with the letter 'a' or ‘b’ or ‘c’ using MySQL query?
• On inserting ‘NULL’, ‘0’ or No Value to the column, will MySQL assign sequence number for AUTO_INCREMENT column?
• What are the other expressions for the word ‘Amazing’?
• How to Use ‘cat’ and ‘tac’ Commands with Examples in Linux