SECOND

Extracts the second component from a given datetime

Updated over a week ago

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)

Output

integer

Variables

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

Example

SECOND(`Event DateTime`)

Event

Event DateTime

SECOND

Event A

2023-09-1010:30:45000-04:00

45

Event B

2023-08-2504:15:30000-04:00

30

Event C

2023-09-0117:00:20000-04:00

20

Did this answer your question?