- 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
How can I use any character, at the place of space, in MySQL TIMESTAMP to distinguish between date and time parts?
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)
- Related Articles
- What MySQL returns on using any other character than ‘T’ or ‘Space’ between date and time parts?
- How can I use IFNULL() function at the place of COALESCE() function in MySQL?
- Which punctuation character can be used as the delimiter between MySQL date parts?
- How can I use TIME_FORMAT() function to offload time/date values in MySQL?
- Set current date and time to timestamp in MySQL
- Which punctuation character can be used as the delimiter between MySQL time parts?
- Combine date and time column into a timestamp in MySQL?
- How can I use SPACE() function with MySQL WHERE clause?
- How to add a specific character to any empty space in MySQL table values?
- How can I get the current time and date in Kotlin?
- How can I use MySQL INTERVAL keyword while extracting the part of the date?
- In MySQL, how can I insert date and time automatically while inserting NULL values to the other columns?
- How to select date from timestamp in MySQL?
- How can we distinguish between MySQL IFNULL() and NULLIF() functions?
- How to use together the date and time format characters in MySQL DATE_FORMAT() function?
Advertisements