SQL Function Reference

UNIX_TIMESTAMP
Returns the Unix timestamp (number of seconds since 1970-01-01 00:00:00 UTC) for the given date or for the current date/time if no argument is given.
MySQL
UNIX_TIMESTAMP([date])
date
Optional. The date or datetime to convert to Unix timestamp. If omitted, returns the current timestamp.
Useful for converting dates to a numeric format for calculations, comparisons, or storage.
Examples
MySQL
SELECT UNIX_TIMESTAMP();
MySQL
SELECT UNIX_TIMESTAMP(date)
FROM Payments;
MySQL
SELECT member_name,
	UNIX_TIMESTAMP(birthday)
FROM FamilyMembers;