How to convert date to timestamp in PHP and MySQL

Convert date stamp to timestamp in PHP

The strtotime() function in PHP can convert date stamp into timestamp. The function of this function is to interpret any description of date and time in English text as 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.

If your date string contains a time, you can add a space and the time after it to convert it to a timestamp. 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.

Date to timestamp in MySQL

UNIX_TIMESTAMP() function can be used in MySQL to convert date-time 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.

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!