в 13:44, 26 мая 2010

2010-05-26T13:44:56Z

Admin: 1 версия

2010-05-26T09:50:42Z

1 версия

Новая страница

== 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")==

<p>GET_FORMAT returns the format string used by DATE_FORMAT</p>



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

← Предыдущая	Версия 13:44, 26 мая 2010
(нет различий)

MySQL Tutorial/Date Time Functions/GET FORMAT - История изменений

в 13:44, 26 мая 2010

Admin: 1 версия