в 13:44, 26 мая 2010

2010-05-26T13:44:56Z

Admin: 1 версия

2010-05-26T09:50:43Z

1 версия

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

== Date arithmetic also can be performed using INTERVAL together with the + or - operator:==



<source lang="sql">
date + INTERVAL expr unit
date - INTERVAL expr unit

mysql>
mysql> SELECT "1997-12-31 23:59:59" + INTERVAL 1 SECOND;
+-------------------------------------------+
| "1997-12-31 23:59:59" + INTERVAL 1 SECOND |
+-------------------------------------------+
| 1998-01-01 00:00:00 |
+-------------------------------------------+
1 row in set (0.00 sec)</source>

== SELECT "1998-01-01" - INTERVAL 1 SECOND;==



<source lang="sql">
mysql>
mysql> SELECT "1998-01-01" - INTERVAL 1 SECOND;
+----------------------------------+
| "1998-01-01" - INTERVAL 1 SECOND |
+----------------------------------+
| 1997-12-31 23:59:59 |
+----------------------------------+
1 row in set (0.00 sec)
mysql></source>

== SELECT INTERVAL 1 DAY + "1997-12-31";==



<source lang="sql">
mysql>
mysql> SELECT INTERVAL 1 DAY + "1997-12-31";
+-------------------------------+
| INTERVAL 1 DAY + "1997-12-31" |
+-------------------------------+
| 1998-01-01 |
+-------------------------------+
1 row in set (0.00 sec)
mysql></source>

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

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

в 13:44, 26 мая 2010

Admin: 1 версия