SECOND: Obtaining the Second Field From Time/Timestamp

How to:

The SECOND function returns the second field from a time or timestamp value.


Top of page

x
Syntax: How to Obtain the Second Field From a Time or Timestamp
SECOND(arg)

where:

arg

Time or timestamp

Is the input value.

This function returns an integer value.



Example: Obtaining the Second Field From a Time or Timestamp

SECOND returns seconds from a time or timestamp. This example,

SECOND('11:22:33')

returns 33.

This example,

SECOND('2001-01-22 12:24:36')

returns 36.


iWay Software