MySQL Tutorial/Date Time Functions/GET FORMAT

GET_FORMAT(DATE,"EUR")

   <source lang="sql">

mysql> mysql> select GET_FORMAT(DATE,"EUR"); +------------------------+ | GET_FORMAT(DATE,"EUR") | +------------------------+ | %d.%m.%Y | +------------------------+ 1 row in set (0.00 sec) mysql></source>

GET_FORMAT(DATE,"INTERNAL")

   <source lang="sql">

mysql> mysql> select GET_FORMAT(DATE,"INTERNAL"); +-----------------------------+ | GET_FORMAT(DATE,"INTERNAL") | +-----------------------------+ | %Y%m%d | +-----------------------------+ 1 row in set (0.00 sec) mysql></source>

GET_FORMAT(DATE,"ISO")

   <source lang="sql">

mysql> mysql> select GET_FORMAT(DATE,"ISO"); +------------------------+ | GET_FORMAT(DATE,"ISO") | +------------------------+ | %Y-%m-%d | +------------------------+ 1 row in set (0.00 sec) mysql></source>

GET_FORMAT(DATE,"JIS")

   <source lang="sql">

mysql> mysql> select GET_FORMAT(DATE,"JIS"); +------------------------+ | GET_FORMAT(DATE,"JIS") | +------------------------+ | %Y-%m-%d | +------------------------+ 1 row in set (0.00 sec) mysql></source>

GET_FORMAT(DATE|TIME|DATETIME, "EUR"|"USA"|"JIS"|"ISO"|"INTERNAL")

GET_FORMAT returns the format string used by DATE_FORMAT

   <source lang="sql">

mysql> mysql> select GET_FORMAT(DATE,"USA"); +------------------------+ | GET_FORMAT(DATE,"USA") | +------------------------+ | %m.%d.%Y | +------------------------+ 1 row in set (0.00 sec) mysql></source>

GET_FORMAT(DATETIME,"EUR")

   <source lang="sql">

mysql> mysql> select GET_FORMAT(DATETIME,"EUR"); +----------------------------+ | GET_FORMAT(DATETIME,"EUR") | +----------------------------+ | %Y-%m-%d %H.%i.%s | +----------------------------+ 1 row in set (0.00 sec) mysql></source>

GET_FORMAT(DATETIME,"INTERNAL")

   <source lang="sql">

mysql> mysql> select GET_FORMAT(DATETIME,"INTERNAL"); +---------------------------------+ | GET_FORMAT(DATETIME,"INTERNAL") | +---------------------------------+ | %Y%m%d%H%i%s | +---------------------------------+ 1 row in set (0.00 sec) mysql></source>

GET_FORMAT(DATETIME,"ISO")

   <source lang="sql">

mysql> mysql> select GET_FORMAT(DATETIME,"ISO"); +----------------------------+ | GET_FORMAT(DATETIME,"ISO") | +----------------------------+ | %Y-%m-%d %H:%i:%s | +----------------------------+ 1 row in set (0.00 sec) mysql></source>

GET_FORMAT(DATETIME,"JIS")

   <source lang="sql">

mysql> mysql> select GET_FORMAT(DATETIME,"JIS"); +----------------------------+ | GET_FORMAT(DATETIME,"JIS") | +----------------------------+ | %Y-%m-%d %H:%i:%s | +----------------------------+ 1 row in set (0.00 sec) mysql></source>

GET_FORMAT(DATETIME,"USA")

   <source lang="sql">

mysql> mysql> select GET_FORMAT(DATETIME,"USA"); +----------------------------+ | GET_FORMAT(DATETIME,"USA") | +----------------------------+ | %Y-%m-%d %H.%i.%s | +----------------------------+ 1 row in set (0.00 sec) mysql></source>

GET_FORMAT(DATE,"USA")

   <source lang="sql">

mysql> mysql> select GET_FORMAT(DATE,"USA"); +------------------------+ | GET_FORMAT(DATE,"USA") | +------------------------+ | %m.%d.%Y | +------------------------+ 1 row in set (0.00 sec) mysql></source>

GET_FORMAT(TIME,"EUR")

   <source lang="sql">

mysql> mysql> mysql> select GET_FORMAT(TIME,"EUR"); +------------------------+ | GET_FORMAT(TIME,"EUR") | +------------------------+ | %H.%i.%s | +------------------------+ 1 row in set (0.00 sec) mysql></source>

GET_FORMAT(TIME,"INTERNAL")

   <source lang="sql">

mysql> mysql> select GET_FORMAT(TIME,"INTERNAL"); +-----------------------------+ | GET_FORMAT(TIME,"INTERNAL") | +-----------------------------+ | %H%i%s | +-----------------------------+ 1 row in set (0.00 sec) mysql></source>

GET_FORMAT(TIME,"ISO")

   <source lang="sql">

mysql> mysql> select GET_FORMAT(TIME,"ISO"); +------------------------+ | GET_FORMAT(TIME,"ISO") | +------------------------+ | %H:%i:%s | +------------------------+ 1 row in set (0.00 sec) mysql></source>

GET_FORMAT(TIME,"JIS")

   <source lang="sql">

mysql> mysql> select GET_FORMAT(TIME,"JIS"); +------------------------+ | GET_FORMAT(TIME,"JIS") | +------------------------+ | %H:%i:%s | +------------------------+ 1 row in set (0.00 sec) mysql></source>

GET_FORMAT(TIME,"USA")

   <source lang="sql">

mysql> mysql> select GET_FORMAT(TIME,"USA"); +------------------------+ | GET_FORMAT(TIME,"USA") | +------------------------+ | %h:%i:%s %p | +------------------------+ 1 row in set (0.00 sec) mysql></source>

SELECT DATE_FORMAT("2003-10-03",GET_FORMAT(DATE,"EUR"));

   <source lang="sql">

mysql> mysql> SELECT DATE_FORMAT("2003-10-03",GET_FORMAT(DATE,"EUR")); +--------------------------------------------------+ | DATE_FORMAT("2003-10-03",GET_FORMAT(DATE,"EUR")) | +--------------------------------------------------+ | 03.10.2003 | +--------------------------------------------------+ 1 row in set (0.00 sec) mysql> mysql> mysql></source>

SELECT STR_TO_DATE("10.31.2003",GET_FORMAT(DATE,"USA"));

   <source lang="sql">

mysql> mysql> SELECT STR_TO_DATE("10.31.2003",GET_FORMAT(DATE,"USA")); +--------------------------------------------------+ | STR_TO_DATE("10.31.2003",GET_FORMAT(DATE,"USA")) | +--------------------------------------------------+ | 2003-10-31 | +--------------------------------------------------+ 1 row in set (0.02 sec) mysql></source>