SECOND

Extracts the second component from a given datetime

Description	The SECOND function extracts and returns the second component from a given datetime. This is useful for time-based analysis, scheduling, or reporting on time-related data.
Syntax	SECOND(datetime)

1. datetime: The datetime from which you want to extract the second component.

Example

Table

Event	Event DateTime
Event A	2023-09-10 14:30:45
Event B	2023-08-25 08:15:30
Event C	2023-09-01 21:00:20

Function

SECOND(`Event DateTime`)

Results

SECOND (integer)
45
30
20