http://sqle.ru/index.php?action=history&feed=atom&title=SQL%2FMySQL%2FDate_Time%2FDate_Time_Function
SQL/MySQL/Date Time/Date Time Function - История изменений
2026-04-06T23:53:09Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=SQL/MySQL/Date_Time/Date_Time_Function&diff=5308&oldid=prev
в 13:46, 26 мая 2010
2010-05-26T13:46:00Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:46, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://sqle.ru/index.php?title=SQL/MySQL/Date_Time/Date_Time_Function&diff=5309&oldid=prev
Admin: 1 версия
2010-05-26T10:16:53Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Using Date/Time Functions in Your SQL Statements==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
/*<br />
mysql> Drop table Transactions;<br />
Query OK, 0 rows affected (0.10 sec)<br />
mysql> CREATE TABLE Transactions (<br />
-> ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,<br />
-> OrderID INT NOT NULL,<br />
-> DVDID SMALLINT NOT NULL,<br />
-> DateOut DATE NOT NULL,<br />
-> DateDue DATE NOT NULL,<br />
-> DateIn DATE NOT NULL<br />
-> )<br />
-> ENGINE=INNODB;<br />
Query OK, 0 rows affected (0.12 sec)<br />
mysql> INSERT INTO Transactions (OrderID, DVDID, DateOut, DateDue)<br />
-> VALUES (1, 1, CURDATE(), CURDATE()+3),<br />
-> (1, 4, CURDATE(), CURDATE()+1),<br />
-> (1, 8, CURDATE(), CURDATE()+2),<br />
-> (2, 3, CURDATE(), CURDATE()+3),<br />
-> (3, 4, CURDATE(), CURDATE()+4),<br />
-> (3, 1, CURDATE(), CURDATE()+5),<br />
-> (3, 7, CURDATE(), CURDATE()+6),<br />
-> (4, 4, CURDATE(), CURDATE()+7),<br />
-> (5, 3, CURDATE(), CURDATE()+8),<br />
-> (6, 2, CURDATE(), CURDATE()+7),<br />
-> (6, 1, CURDATE(), CURDATE()+6),<br />
-> (7, 4, CURDATE(), CURDATE()+6),<br />
-> (8, 2, CURDATE(), CURDATE()+5),<br />
-> (8, 1, CURDATE(), CURDATE()+4),<br />
-> (8, 3, CURDATE(), CURDATE()+4),<br />
-> (9, 7, CURDATE(), CURDATE()+3),<br />
-> (9, 1, CURDATE(), CURDATE()+3),<br />
-> (10, 5, CURDATE(), CURDATE()+1),<br />
-> (11, 6, CURDATE(), CURDATE()+2),<br />
-> (11, 2, CURDATE(), CURDATE()+6),<br />
-> (11, 8, CURDATE(), CURDATE()+5),<br />
-> (12, 5, CURDATE(), CURDATE()+4),<br />
-> (13, 7, CURDATE(), CURDATE()+3);SELECT ID, YEAR(DateOut) AS YearOu<br />
t<br />
Query OK, 23 rows affected (0.08 sec)<br />
Records: 23 Duplicates: 0 Warnings: 0<br />
-> FROM Transactions<br />
-> WHERE ID>15<br />
-> ORDER BY ID;<br />
+----+---------+<br />
| ID | YearOut |<br />
+----+---------+<br />
| 16 | 2005 |<br />
| 17 | 2005 |<br />
| 18 | 2005 |<br />
| 19 | 2005 |<br />
| 20 | 2005 |<br />
| 21 | 2005 |<br />
| 22 | 2005 |<br />
| 23 | 2005 |<br />
+----+---------+<br />
8 rows in set (0.00 sec)<br />
*/<br />
Drop table Transactions;<br />
CREATE TABLE Transactions (<br />
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,<br />
OrderID INT NOT NULL,<br />
DVDID SMALLINT NOT NULL,<br />
DateOut DATE NOT NULL,<br />
DateDue DATE NOT NULL,<br />
DateIn DATE NOT NULL<br />
)<br />
ENGINE=INNODB;<br />
INSERT INTO Transactions (OrderID, DVDID, DateOut, DateDue)<br />
VALUES (1, 1, CURDATE(), CURDATE()+3),<br />
(1, 4, CURDATE(), CURDATE()+1),<br />
(1, 8, CURDATE(), CURDATE()+2),<br />
(2, 3, CURDATE(), CURDATE()+3),<br />
(3, 4, CURDATE(), CURDATE()+4),<br />
(3, 1, CURDATE(), CURDATE()+5),<br />
(3, 7, CURDATE(), CURDATE()+6),<br />
(4, 4, CURDATE(), CURDATE()+7),<br />
(5, 3, CURDATE(), CURDATE()+8),<br />
(6, 2, CURDATE(), CURDATE()+7),<br />
(6, 1, CURDATE(), CURDATE()+6),<br />
(7, 4, CURDATE(), CURDATE()+6),<br />
(8, 2, CURDATE(), CURDATE()+5),<br />
(8, 1, CURDATE(), CURDATE()+4),<br />
(8, 3, CURDATE(), CURDATE()+4),<br />
(9, 7, CURDATE(), CURDATE()+3),<br />
(9, 1, CURDATE(), CURDATE()+3),<br />
(10, 5, CURDATE(), CURDATE()+1),<br />
(11, 6, CURDATE(), CURDATE()+2),<br />
(11, 2, CURDATE(), CURDATE()+6),<br />
(11, 8, CURDATE(), CURDATE()+5),<br />
(12, 5, CURDATE(), CURDATE()+4),<br />
(13, 7, CURDATE(), CURDATE()+3);<br />
<br />
SELECT ID, YEAR(DateOut) AS YearOut<br />
FROM Transactions<br />
WHERE ID>15<br />
ORDER BY ID;<br />
<br />
<br />
</source></div>
Admin