SECOND

The SECOND function reads a date and returns the seconds portion of the time.

Syntax

SECOND(date)

Return

A number in the format: ss

Range 0 - 59

Example

SECOND('06/23/2010 12:45') = 00