How to convert date to timestamp in PHP and MySQL

For PHP and MySQL developers, converting date stamps and timestamps has become a required course in daily work, but for novices, this seems to be a difficult task. In this article, we will discuss how to convert date to timestamp in PHP and MySQL.

Convert date stamp to timestamp in PHP

In PHP, we can use the built-in strtotime() function to convert date stamp to timestamp. What this function does is parse any English text datetime description into a Unix timestamp. The following is a basic example of converting a date stamp into a timestamp:

$timestamp = strtotime("2021-08-18");
echo $timestamp; // 输出 1629244800

The above code will convert the date stamp "2021-08-18" into a timestamp 1629244800 and output it on the screen.

Also, if your date string contains time, you can convert the timestamp by adding a space and the time. The following is an example of converting a date stamp and a timestamp together into a timestamp:

$timestamp = strtotime("2021-08-18 16:30:00");
echo $timestamp; // 输出 1629280200

In this example, the date stamp "2021-08-18" and the time "16:30:00" are both parsed The timestamp is 1629280200.

Convert date to timestamp in MySQL

In MySQL, we can use the UNIX_TIMESTAMP() function to convert date stamp to timestamp. This function converts a datetime value to a Unix timestamp. The following is a basic example of converting a date stamp into a timestamp:

SELECT UNIX_TIMESTAMP('2021-08-18');
-- 输出 1629244800

The above code will convert the date stamp "2021-08-18" into a timestamp 1629244800 and output it in the query results.

Also, if your date string contains time, you can use the STR_TO_DATE() function to convert the string to datetime format, and the UNIX_TIMESTAMP() function to convert the datetime value to a Unix timestamp. The following is an example of converting a date stamp and a timestamp together into a timestamp:

SELECT UNIX_TIMESTAMP(STR_TO_DATE('2021-08-18 16:30:00', '%Y-%m-%d %H:%i:%s'));
-- 输出 1629280200

In this example, the date stamp "2021-08-18" and the time "16:30:00" are both converted as a datetime value, and then use the UNIX_TIMESTAMP() function to convert it to a Unix timestamp of 1629280200.

Conclusion

Converting date to timestamp in PHP and MySQL is not difficult. In PHP, we use the strtotime() function to achieve conversion, and in MySQL, we use the UNIX_TIMESTAMP() function to achieve conversion. To convert a date stamp to a timestamp together with a timestamp, we can add a space and time to the date string and use the relevant functions to convert it to a Unix timestamp. Hope this article is helpful to you.

The above is the detailed content of How to convert date to timestamp in PHP and MySQL. For more information, please follow other related articles on the PHP Chinese website!