- 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 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)
Updated on 29-Jan-2020 06:51:13
- Related Questions & Answers
- 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?
- 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?
- 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?
- MySQL CAST as DATE?
- What are the different wildcard characters which can be used with NOT LIKE operator?
Advertisements