MySQL Function Reference

SECOND

Returns the seconds (0-59) from a time or datetime value.

MySQL 8.1

SECOND(time)

time

The time or datetime value.

Examples

MySQL 8.1

SELECT SECOND(date)
FROM Payments;

MySQL 8.1

SELECT member_name,
	SECOND(birthday)
FROM FamilyMembers;