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)

Prabhas

Published on 19-Feb-2018 10:39:58

• 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?
• Set whether a punctuation character may be placed outside the line box with CSS
• Which MySQL function can be used to append values of a column with single quotes?
• What are the different wildcard characters which can be used with NOT LIKE operator?
• MySQL CAST as DATE?
• How can Tensorflow be used in the conversion between different string representations?