What is the range of datetime values we can pass as parameters to the MySQL UNIX_TIMESTAMP function?-Mysql Tutorial-php.cn

What is the range of datetime values we can pass as parameters to the MySQL UNIX_TIMESTAMP function?

WBOY

Release： 2023-09-03 21:01:02

forward

854 people have browsed it

我们可以作为参数传递给 MySQL UNIX_TIMESTAMP 函数的日期时间值的范围是多少？

The range of datetime values that we can pass as parameters to the MySQL UNIX_TIMESTAMP function is the same as the range of the TIMESTAMP data type, i.e. between "1970-01-01 00:00:01" to "2038-01-" between 19 08:44:07'. If the datetime value we give in the UNIX_TIMESTAMP function is outside or below the TIMESTAMP range, MySQL will return 0 as output. You can understand with the help of the following examples -

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)

Copy after login

The above is the detailed content of What is the range of datetime values we can pass as parameters to the MySQL UNIX_TIMESTAMP function?. For more information, please follow other related articles on the PHP Chinese website!