Built-in Functions → second

second() is a conversion function that returns the seconds component of a timestamp or date expression.

Signature

Copy
second(date_timestamp exp)

• date_timestamp exp : The date or timestamp value

Returns

double

Example

Extract the seconds component of the timestamp expression from TIME_SOLD.

Copy
second(INCORTA.SALES.TIME_SOLD)