Seconds

Returns a number representing the seconds portion (0 to 59) of a specified time.

Format 

Seconds ( time )

Parameters 

time - any time value or field of type time

Data type returned 

number

Originated in version 

6.0 or earlier

Notes 

  • If time includes no seconds component (such as "4:15 PM"), 0 is returned.

Example 1 

Seconds ( "12:15:23" ) returns 23.

Related topics