в 13:44, 26 мая 2010

2010-05-26T13:44:56Z

Admin: 1 версия

2010-05-26T09:50:36Z

1 версия

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

== SELECT TIMESTAMPDIFF(DAY,"2003-02-01","2003-05-01");==



<source lang="sql">
mysql>
mysql> SELECT TIMESTAMPDIFF(DAY,"2003-02-01","2003-05-01");
+----------------------------------------------+
| TIMESTAMPDIFF(DAY,"2003-02-01","2003-05-01") |
+----------------------------------------------+
| 89 |
+----------------------------------------------+
1 row in set (0.00 sec)
mysql></source>

== SELECT TIMESTAMPDIFF(FRAC_SECOND,"2003-02-01","2003-05-01");==



<source lang="sql">
mysql>
mysql> SELECT TIMESTAMPDIFF(FRAC_SECOND,"2003-02-01","2003-05-01");
+------------------------------------------------------+
| TIMESTAMPDIFF(FRAC_SECOND,"2003-02-01","2003-05-01") |
+------------------------------------------------------+
| 7689600000000 |
+------------------------------------------------------+
1 row in set (0.00 sec)</source>

== SELECT TIMESTAMPDIFF(HOUR,"2003-02-01","2003-05-01");==



<source lang="sql">
mysql>
mysql>
mysql> SELECT TIMESTAMPDIFF(HOUR,"2003-02-01","2003-05-01");
+-----------------------------------------------+
| TIMESTAMPDIFF(HOUR,"2003-02-01","2003-05-01") |
+-----------------------------------------------+
| 2136 |
+-----------------------------------------------+
1 row in set (0.00 sec)
mysql></source>

== SELECT TIMESTAMPDIFF(MINUTE,"2003-02-01","2003-05-01");==



<source lang="sql">
mysql>
mysql> SELECT TIMESTAMPDIFF(MINUTE,"2003-02-01","2003-05-01");
+-------------------------------------------------+
| TIMESTAMPDIFF(MINUTE,"2003-02-01","2003-05-01") |
+-------------------------------------------------+
| 128160 |
+-------------------------------------------------+
1 row in set (0.00 sec)</source>

== SELECT TIMESTAMPDIFF(MONTH,"2003-02-01","2003-05-01");==



<source lang="sql">
mysql>
mysql> SELECT TIMESTAMPDIFF(MONTH,"2003-02-01","2003-05-01");
+------------------------------------------------+
| TIMESTAMPDIFF(MONTH,"2003-02-01","2003-05-01") |
+------------------------------------------------+
| 3 |
+------------------------------------------------+
1 row in set (0.00 sec)
mysql></source>

== SELECT TIMESTAMPDIFF(QUARTER,"2003-02-01","2003-05-01");==



<source lang="sql">
mysql>
mysql> SELECT TIMESTAMPDIFF(QUARTER,"2003-02-01","2003-05-01");
+--------------------------------------------------+
| TIMESTAMPDIFF(QUARTER,"2003-02-01","2003-05-01") |
+--------------------------------------------------+
| 1 |
+--------------------------------------------------+
1 row in set (0.01 sec)
mysql></source>

== SELECT TIMESTAMPDIFF(SECOND,"2003-02-01","2003-05-01");==



<source lang="sql">
mysql>
mysql> SELECT TIMESTAMPDIFF(SECOND,"2003-02-01","2003-05-01");
+-------------------------------------------------+
| TIMESTAMPDIFF(SECOND,"2003-02-01","2003-05-01") |
+-------------------------------------------------+
| 7689600 |
+-------------------------------------------------+
1 row in set (0.00 sec)
mysql></source>

== SELECT TIMESTAMPDIFF(WEEK,"2003-02-01","2003-05-01");==



<source lang="sql">
mysql>
mysql>
mysql> SELECT TIMESTAMPDIFF(WEEK,"2003-02-01","2003-05-01");
+-----------------------------------------------+
| TIMESTAMPDIFF(WEEK,"2003-02-01","2003-05-01") |
+-----------------------------------------------+
| 12 |
+-----------------------------------------------+
1 row in set (0.00 sec)
mysql></source>

== SELECT TIMESTAMPDIFF(YEAR,"2002-05-01","2001-01-01");==



<source lang="sql">
mysql>
mysql> SELECT TIMESTAMPDIFF(YEAR,"2002-05-01","2001-01-01");
+-----------------------------------------------+
| TIMESTAMPDIFF(YEAR,"2002-05-01","2001-01-01") |
+-----------------------------------------------+
| -1 |
+-----------------------------------------------+
1 row in set (0.00 sec)
mysql></source>

== SELECT TIMESTAMPDIFF(YEAR,"2003-02-01","2003-05-01");==



<source lang="sql">
mysql>
mysql> SELECT TIMESTAMPDIFF(YEAR,"2003-02-01","2003-05-01");
+-----------------------------------------------+
| TIMESTAMPDIFF(YEAR,"2003-02-01","2003-05-01") |
+-----------------------------------------------+
| 0 |
+-----------------------------------------------+
1 row in set (0.00 sec)
mysql></source>

== TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2): Returns the integer difference between datetime_expr1 and datetime_expr2==

<p>The unit for the result is given by the unit argument.</p>
<p>The unit should be one of the following values:</p>
<OL><LI>FRAC_SECOND,</LI><LI>SECOND,</LI><LI>MINUTE,</LI><LI>HOUR,</LI><LI>DAY,</LI><LI>WEEK,</LI><LI>MONTH,</LI><LI>QUARTER, or</LI><LI>YEAR.</LI></OL>



<source lang="sql">
mysql>
mysql> SELECT TIMESTAMPDIFF(MONTH,"2003-02-01","2003-05-01");
+------------------------------------------------+
| TIMESTAMPDIFF(MONTH,"2003-02-01","2003-05-01") |
+------------------------------------------------+
| 3 |
+------------------------------------------------+
1 row in set (0.00 sec)</source>

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

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

в 13:44, 26 мая 2010

Admin: 1 версия