1. Home
  2. Other Releases
  3. On-premises 5.1
  4. Guides
  5. Tours
  6. Concepts
  7. Tools
  8. References
  9. Integrations
  10. Data applications
  11. Releases

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 or timestamp value

Returns

double

Example

Extract the seconds component of the timestamp expression from TIME_SOLD.

second(INCORTA.SALES.TIME_SOLD)