How to get the format specifier string for a given datetime standards using the GET_FORMAT() function?

GET_FORMAT(part, std) is a MySQL built-in function that returns the format specifier string of a datetime part for a given standard. For example:

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

SELECT DATE_FORMAT(NOW(), GET_FORMAT(DATE, 'EUR'));
  -- +---------------------------------------------+
  -- | DATE_FORMAT(NOW(), GET_FORMAT(DATE, 'EUR')) |
  -- +---------------------------------------------+
  -- | 14.11.2023                                  |
  -- +---------------------------------------------+

SELECT DATE_FORMAT(NOW(), GET_FORMAT(DATETIME, 'EUR'));
  -- +-------------------------------------------------+
  -- | DATE_FORMAT(NOW(), GET_FORMAT(DATETIME, 'EUR')) |
  -- +-------------------------------------------------+
  -- | 2023-11-14 22.34.18                             |
  -- +-------------------------------------------------+

Reference information of the GET_FORMAT() function:

GET_FORMAT(part, std): format
  Returns a format specifier string of a datetime part for a given standard std.
  part is a keyword of DATE, TIME or DATETIME.
  std is a standard name of 'EUR', 'USA', 'JIS', 'ISO' or 'INTERNAL'.

Arguments, return value and availability:
  part: Required. The datetime part keyword.
  std: Required. The format standard name.
  format: Return value. The format specifier string.
  Available since MySQL 5.7.

⇒ HOUR() - Hours of Time

⇐ FROM_UNIXTIME() - Unix Time to Datetime

⇑ MySQL Functions on Date and Time

⇑⇑ MySQL Function References