MS Access Second() Function
Example
Return the second of the minute for a specified time:
SELECT
Second(#14:48:23#);
Try it Yourself »
Definition and Usage
The Second() function returns the second of the minute (from 0 to 59) for a time value.
Syntax
Second(time)Parameter Values
| Parameter | Description |
|---|---|
| time | Required. A valid time |
Technical Details
| Works in: | Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000 |
|---|
More Examples
Example
Return the second of the minute for the current time:
SELECT
Second(Now());
Try it Yourself »
Example
Return the second of the minute for a specified date and time:
SELECT
Second(#24/10/2016 11:18:34 PM#);
Try it Yourself »
