Get MySQL Timestamp: UNIX_TIMESTAMP Guide

To get a timestamp in MySQL, you can use the UNIX_TIMESTAMP() function. This function returns the UNIX timestamp of the current date and time, which represents the number of seconds since January 1, 1970. Here is an example:

SELECT UNIX_TIMESTAMP();

This will return the UNIX timestamp of the current date and time. You can also convert a specific date and time to a timestamp, for example:

SELECT UNIX_TIMESTAMP('2022-01-01 00:00:00');

This will return the UNIX timestamp of the specified date and time.