second

Return the second

Syntax

second(dt_expr)

Arguments

dt_expr

A time expression.

Description

This function returns the seconds component in the specified time expression as a number between 0 and 59.

Example

select second(curtime()) as "Current Second";

Current Second
            29