- 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 date parts?
In this matter, MySQL permits us to use a relaxed format to date. We can use any punctuation character between date parts as a delimiter. Some examples are as follows −
mysql> Select date ('2016/10/20'); +---------------------+ | date ('2016/10/20') | +---------------------+ | 2016-10-20 | +---------------------+ 1 row in set (0.00 sec) mysql> Select date('2016^10^20'); +--------------------+ | date('2016^10^20') | +--------------------+ | 2016-10-20 | +--------------------+ 1 row in set (0.00 sec) mysql> Select date ('2016@10@20'); +---------------------+ | date ('2016@10@20') | +---------------------+ | 2016-10-20 | +---------------------+ 1 row in set (0.00 sec) mysql> Select date ('2016+10+20'); +---------------------+ | date ('2016+10+20') | +---------------------+ | 2016-10-20 | +---------------------+ 1 row in set (0.00 sec)
- Related Articles
- Which punctuation character can be used as the delimiter between MySQL time parts?
- How can MySQL interpret the number and string, having no delimiter, as a date?
- 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.
- 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 Tensorflow be used to work with character substring in Python?
- MySQL CAST as DATE?
- 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