- 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
Which punctuation character can be used as the delimiter between MySQL time parts?
As in the case of date values, MySQL also permits us to use a relaxed format for time. We can use any punctuation character between time parts as a delimiter. Some examples are as follows −
mysql> Select timestamp('2017-10-20 04+05+36');
+----------------------------------+
| timestamp('2017-10-20 04+05+36') |
+----------------------------------+
| 2017-10-20 04:05:36 |
+----------------------------------+
1 row in set (0.00 sec)
mysql> Select timestamp('2017-10-20 04*05*36');
+----------------------------------+
| timestamp('2017-10-20 04*05*36') |
+----------------------------------+
| 2017-10-20 04:05:36 |
+----------------------------------+
1 row in set (0.00 sec)
mysql> Select timestamp('2017-10&20 04@05+36');
+----------------------------------+
| timestamp('2017-10&20 04@05+36') |
+----------------------------------+
| 2017-10-20 04:05:36 |
+----------------------------------+
1 row in set (0.00 sec)
mysql> Select timestamp('2017*10@20 04*05*36');
+----------------------------------+
| timestamp('2017*10@20 04*05*36') |
+----------------------------------+
| 2017-10-20 04:05:36 |
+----------------------------------+
1 row in set (0.00 sec)
Updated on 29-Jan-2020 06:50:19
- Related Questions & Answers
- Which punctuation character can be used as the delimiter between MySQL date parts?
- Which MySQL query can be used with the help of which we can see the list of MySQL databases?
- Which MySQL Data Type can be used to store Negative Number?
- How can I use any character, at the place of space, in MySQL TIMESTAMP to distinguish between date and time parts?
- Which MySQL function can be used to find out the length of the string in bits?
- Which MySQL Datatype should be used for storing BloodType?
- What function in MySQL can be used to get the number code of a specific character?
- How can MySQL interpret the number and string, having no delimiter, as a date?
- How can Matplotlib be used to generate time-series data?
- What are the curries in which cinnamon can be used to improve the taste?
- Which library can be used to interact with database in JSP?
- Which MySQL function can be used to append values of a column with single quotes?
- Set whether a punctuation character may be placed outside the line box with CSS
- How can Tensorflow be used to work with character substring in Python?
- What are the different wildcard characters which can be used with NOT LIKE operator?
Advertisements