亚洲视频二区_亚洲欧洲日本天天堂在线观看_日韩一区二区在线观看_中文字幕不卡一区

當(dāng)我們嘗試對(duì)表中存儲(chǔ)的日期值進(jìn)行此類操作時(shí)，MySQL 會(huì)將日期值假設(shè)為數(shù)字并執(zhí)行算術(shù)運(yùn)算。

假設(shè)我們有一個(gè)名為“example”的表在“orderdate”列中有一個(gè)日期值，然后進(jìn)行算術(shù)運(yùn)算將澄清上述內(nèi)容 –

mysql> select * from example;
+------------+
| orderdate  |
+------------+
| 2017-05-25 |
+------------+
1 row in set (0.00 sec)

mysql> select orderdate+10 from example;
+--------------+
| orderdate+10 |
+--------------+
|     20170535 |
+--------------+
1 row in set (0.00 sec)

mysql> select orderdate*10 from example;
+--------------+
| orderdate*10 |
+--------------+
|    201705250 |
+--------------+
1 row in set (0.00 sec)

mysql> select orderdate-10 from example;
+--------------+
| orderdate-10 |
+--------------+
|     20170515 |
+--------------+
1 row in set (0.00 sec)

mysql> select orderdate/10 from example;
+--------------+
| orderdate/10 |
+--------------+
|    2017052.5 |
+--------------+
1 row in set (0.00 sec)

登錄后復(fù)制

以上就是加法、減法、乘法和除法運(yùn)算符如何處理 MySQL 表中存儲(chǔ)的日期值？的詳細(xì)內(nèi)容，更多請(qǐng)關(guān)注www.92cms.cn其它相關(guān)文章！