- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- 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)
- Related Articles
- Which punctuation character can be used as the delimiter between MySQL date parts?
- How can I use any character, at the place of space, in MySQL TIMESTAMP to distinguish between date and time parts?
- What MySQL returns on using any other character than ‘T’ or ‘Space’ between date and time parts?
- Which MySQL query can be used with the help of which we can see the list of MySQL databases?
- Name any five plant parts which are used as food.
- How can MySQL interpret the number and string, having no delimiter, as a date?
- What function in MySQL can be used to get the number code of a specific character?
- Which MySQL Data Type can be used to store Negative Number?
- Set whether a punctuation character may be placed outside the line box with CSS
- Which MySQL function can be used to find out the length of the string in bits?
- How can Matplotlib be used to generate time-series data?
- How can Tensorflow be used to work with character substring in Python?
- How MySQL LEFT JOIN can be used to simulate the MySQL MINUS query?
- Name any two substances that can be used as indicators.
- Which MySQL function can be used to append values of a column with single quotes?

Advertisements