second

datetime

Extracts the second from a timestamp

Syntax

second(date)

date (timestamp)

The timestamp value to extract the second from

number

The second (0-59)

Input:

second("2024-03-15 14:30:45")

Output:

Get the current second

Input:

second(now())

Output:

Extract second from a time field

Input:

.time | second

Output:

The second() function extracts the second component from a timestamp value, returning a number from 0 to 59.

Use second() to work with high-precision timestamps, analyze sub-minute patterns, or extract time components for detailed temporal analysis.