GET_FORMAT()
GET_FORMAT() is a SQL function in the MySQL Specific category. MySQL: returns a format string for date/time formatting based on standard formats (USA, EUR, ISO, etc.). The syntax is GET_FORMAT(DATE, 'USA' / 'EUR' / 'ISO' / 'INTERNAL'). It accepts see syntax. It returns format string. A typical example: SELECT DATE_FORMAT(NOW(), GET_FORMAT(DATE, 'USA')); -- '06:06:2026' SELECT DATE_FORMAT(NOW(), GET_FORMAT(DATE, 'EUR')); -- '06.06.2026' SELECT DATE_FORMAT(NOW(), GET_FORMAT(DATE, 'ISO')); -- '2026-06-06' SELECT DATE_FORMAT(NOW(), GET_FORMAT(DATE, 'INTERNAL')); -- '20260606' A close relative is AUTO_INCREMENT, which mySQL auto-generates sequential integer values for this column. Commonly used with PRIMARY KEY. A close relative is ENGINE, which specifies the MySQL storage engine. InnoDB (default) supports transactions and foreign keys. MyISAM is faster for read-heavy. A close relative is LAST_INSERT_ID(), which returns the AUTO_INCREMENT value generated by the most recent INSERT in the current connection. More about this category: MySQL-specific features — AUTO_INCREMENT, ENGINE, SHOW TABLES, LIMIT.