GET_FORMAT

Return a format string for the specified datetime type and standard.

The result format string can be used with STR_TO_DATE and SEC_TO_TIME.

Syntax

GET_FORMAT ({DATE | DATETIME | DATE}, {'EUR' | 'ISO' | 'JIS' | 'USA' | 'INTERNAL'})

Return Type

DATE_FORMAT

Examples

SELECT GET_FORMAT(DATE, 'USA');
+-------------------------+
| GET_FORMAT(DATE, 'USA') |
+-------------------------+
| %m.%d.%Y                |
+-------------------------+
SELECT GET_FORMAT(DATETIME, 'INTERNAL');
+----------------------------------+
| GET_FORMAT(DATETIME, 'INTERNAL') |
+----------------------------------+
| %Y%m%d%H%i%s                     |
+----------------------------------+

Related Topics

Last modified: May 31, 2023

Was this article helpful?