GET_FORMAT()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
Returns a format string. This function is useful in combination with the DATE_
EXAMPLES
SELECT DATE_FORMAT('2020-01-02',GET_FORMAT(DATE,'EUR'));
+--------------------------------------------------+
| DATE_FORMAT('2020-01-02',GET_FORMAT(DATE,'EUR')) |
+--------------------------------------------------+
| 02.01.2020 |
+--------------------------------------------------+
SELECT STR_TO_DATE('01.02.2020',GET_FORMAT(DATE,'USA'));
+--------------------------------------------------+
| STR_TO_DATE('01.02.2020',GET_FORMAT(DATE,'USA')) |
+--------------------------------------------------+
| 2020-01-02 |
+--------------------------------------------------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.