- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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)
Updated on 29-Jan-2020 06:48:45
- Related Questions & Answers
- How can I use any character, at the place of space, in MySQL TIMESTAMP to distinguish between date and time parts?
- Which punctuation character can be used as the delimiter between MySQL date parts?
- Which punctuation character can be used as the delimiter between MySQL time parts?
- Get Date and Time parts separately in Java
- How can we insert current date and time automatically on inserting values in other columns in MySQL?
- Do gold ornaments serve any other purpose other than being symbols of wealth and vanity?
- Display nanoseconds with Java Date and Time Conversion Character
- Get current time and date on Android
- What is filtered coffee? Is it any better than other forms of coffee?
- How to add a specific character to any empty space in MySQL table values?
- What is the difference between humans and other species on earth?
- What MySQL EXPORT_SET() function returns if any of the argument is NULL?
- Are there any other ways I can improve my concentration other than the Rubic Cube?
- What MySQL returns if we include time components along with date component as an argument to DATEDIFF() function?
- What MySQL returns if we include date components along with time component as an argument to TIMEDIFF() function?
Advertisements