Second

Retrieve the seconds component from a specified time.

SELECT Second(#14:48:23#);

Definition and Usage

The Second() function retrieves the seconds component from a time or datetime value, returning an integer between 0 and 59.

Second(time)

Parameter	Description
time	Required. A numeric or string expression that represents a valid time or datetime value.

WORKS IN

From Access 2000

Retrieve the seconds component of the current time.

SELECT Second(Now());

Retrieve the seconds component from a specified datetime.

SELECT Second(#24/10/2016 11:18:34 PM#);