MySQL Tutorial/Date Time Functions/GET FORMAT
Содержание
- 1 GET_FORMAT(DATE,"EUR")
- 2 GET_FORMAT(DATE,"INTERNAL")
- 3 GET_FORMAT(DATE,"ISO")
- 4 GET_FORMAT(DATE,"JIS")
- 5 GET_FORMAT(DATE|TIME|DATETIME, "EUR"|"USA"|"JIS"|"ISO"|"INTERNAL")
- 6 GET_FORMAT(DATETIME,"EUR")
- 7 GET_FORMAT(DATETIME,"INTERNAL")
- 8 GET_FORMAT(DATETIME,"ISO")
- 9 GET_FORMAT(DATETIME,"JIS")
- 10 GET_FORMAT(DATETIME,"USA")
- 11 GET_FORMAT(DATE,"USA")
- 12 GET_FORMAT(TIME,"EUR")
- 13 GET_FORMAT(TIME,"INTERNAL")
- 14 GET_FORMAT(TIME,"ISO")
- 15 GET_FORMAT(TIME,"JIS")
- 16 GET_FORMAT(TIME,"USA")
- 17 SELECT DATE_FORMAT("2003-10-03",GET_FORMAT(DATE,"EUR"));
- 18 SELECT STR_TO_DATE("10.31.2003",GET_FORMAT(DATE,"USA"));
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>