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

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

Syntax

MYSQL Copy

SELECT DATE_FORMAT('2003-10-03',GET_FORMAT(DATE,'EUR'));
'03.10.2003'
SELECT STR_TO_DATE('10.31.2003',GET_FORMAT(DATE,'USA'));
'2003-10-31'

Examples

Example

Returns a format string. This function is useful in combination with the DATE_FORMAT() and the STR_TO_DATE() functions.

MYSQL Copy

SELECT DATE_FORMAT('2003-10-03',GET_FORMAT(DATE,'EUR'));
'03.10.2003'
SELECT STR_TO_DATE('10.31.2003',GET_FORMAT(DATE,'USA'));
'2003-10-31'