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
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