Built-in Functions → second
second() is a conversion function that returns the seconds component of a timestamp
or date
expression.
Signature
second(date_timestamp exp)
- date_timestamp exp : The
date
ortimestamp
value
Returns
double
Example
Extract the seconds component of the timestamp
expression from TIME_SOLD.
second(INCORTA.SALES.TIME_SOLD)