- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
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)
- Related Articles
- 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?
- How to add a specific character to any empty space in MySQL table values?
- 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?
- Display nanoseconds with Java Date and Time Conversion Character
- What MySQL EXPORT_SET() function returns if any of the argument is NULL?
- Displaymilliseconds since the epoch with Java Date and Time Conversion Character
- What MySQL returns if we provide an empty string for padding with other string in LPAD() or RPAD() functions?
- MySQL - Insert current date/time?
- Get current time and date on Android
- Create DATETIME from DATE and TIME in MySQL?
Advertisements