日日操夜夜添-日日操影院-日日草夜夜操-日日干干-精品一区二区三区波多野结衣-精品一区二区三区高清免费不卡

當(dāng)我們嘗試從日期中提取小時(shí)值時(shí)，EXTRACT() 函數(shù)將給出輸出 0 并帶有警告，如下面給出的示例所示 –

mysql> Select EXTRACT(Hour from '2017-10-20');

+---------------------------------+
| EXTRACT(Hour from '2017-10-20') |
+---------------------------------+
| 0                               |
+---------------------------------+
1 row in set, 1 warning (0.00 sec)

mysql> Show Warnings;

+---------+------+----------------------------------------------+
| Level   | Code | Message                                      |
+---------+------+----------------------------------------------+
| Warning | 1292 | Truncated incorrect time value: '2017-10-20' |
+---------+------+----------------------------------------------+
1 row in set (0.00 sec)

登錄后復(fù)制

現(xiàn)在，當(dāng)我們嘗試從日期中提取分鐘值時(shí)，EXTRACT() 函數(shù)將給出日期中的世紀(jì)值作為輸出，并帶有警告，如下面給出的示例所示 –

mysql> Select EXTRACT(Minute from '2017-10-20');
+-----------------------------------+
| EXTRACT(Minute from '2017-10-20') |
+-----------------------------------+
| 20                                |
+-----------------------------------+
1 row in set, 1 warning (0.00 sec)
mysql> Show Warnings;
+---------+------+----------------------------------------------+
| Level   | Code | Message                                      |
+---------+------+----------------------------------------------+
| Warning | 1292 | Truncated incorrect time value: '2017-10-20' |
+---------+------+----------------------------------------------+
1 row in set (0.00 sec)

登錄后復(fù)制

現(xiàn)在，當(dāng)我們嘗試從日期中提取秒值時(shí)，EXTRACT() 函數(shù)將給出年份值作為輸出，并帶有警告，如下面給出的示例所示 –

mysql> Select Extract(Second from '2017-10-20');

+-----------------------------------+
| Extract(Second from '2017-10-20') |
+-----------------------------------+
| 17                                |
+-----------------------------------+
1 row in set, 1 warning (0.00 sec)

mysql> Show Warnings;

+---------+------+----------------------------------------------+
| Level   | Code | Message                                      |
+---------+------+----------------------------------------------+
| Warning | 1292 | Truncated incorrect time value: '2017-10-20' |
+---------+------+----------------------------------------------+
1 row in set (0.00 sec)

登錄后復(fù)制

嘗試從當(dāng)前日期獲取時(shí)間值（小時(shí)、分鐘和秒），即通過在日期位置使用 Curdate() ，我們會(huì)得到類似的結(jié)果。

以上就是如果我們嘗試僅向 MySQL EXTRACT() 函數(shù)提供日期值來提取時(shí)間值，會(huì)輸出什么？的詳細(xì)內(nèi)容，更多請(qǐng)關(guān)注www.92cms.cn其它相關(guān)文章！