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

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)

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!