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

我們可以作為參數(shù)傳遞給MySQL UNIX_TIMESTAMP函數(shù)的日期時(shí)間值的范圍與TIMESTAMP數(shù)據(jù)類型的范圍相同，即在“1970-01-01 00:00:01”到“2038-01-”之間19 08:44:07’。如果我們?cè)?UNIX_TIMESTAMP 函數(shù)中給出的日期時(shí)間值超出或低于 TIMESTAMP 范圍，MySQL 將返回 0 作為輸出。可以借助以下示例來理解 –

mysql> select UNIX_TIMESTAMP('2038-01-19 08:44:07');
+---------------------------------------+
| UNIX_TIMESTAMP('2038-01-19 08:44:07') |
+---------------------------------------+
| 2147483647                            |
+---------------------------------------+
1 row in set (0.00 sec)

mysql> select UNIX_TIMESTAMP('2038-01-19 08:44:08');
+---------------------------------------+
| UNIX_TIMESTAMP('2038-01-19 08:44:08') |
+---------------------------------------+
|                                   0   |
+---------------------------------------+
1 row in set (0.00 sec)

mysql> select UNIX_TIMESTAMP('1969-01-01 05:10:00');
+---------------------------------------+
| UNIX_TIMESTAMP('1969-01-01 05:10:00') |
+---------------------------------------+
|                                    0  |
+---------------------------------------+
1 row in set (0.00 sec)

登錄后復(fù)制

以上就是我們可以作為參數(shù)傳遞給 MySQL UNIX_TIMESTAMP 函數(shù)的日期時(shí)間值的范圍是多少？的詳細(xì)內(nèi)容，更多請(qǐng)關(guān)注www.92cms.cn其它相關(guān)文章！