MS Access Second() Function
Clash Royale CLAN TAG#URR8PPP
googletag.cmd.push(function() googletag.display('div-gpt-ad-1422003450156-2'); );
MS Access Second() Function
❮ MS Access Functions
Example
Return the seconds part of a specified time:
SELECT
Second(#14:48:23#);Try it Yourself »
Definition and Usage
The Second() function returns the seconds part of a time/datetime.
This function returns an integer between 0 and 59.
Syntax
Second(time)Parameter Values
| Parameter | Description |
|---|---|
| time | Required. A numeric or string expression that can represent a valid time/datetime |
Technical Details
| Works in: | From Access 2000 |
|---|
More Examples
Example
Return the seconds part of the current time:
SELECT
Second(Now());Try it Yourself »
Example
Return the seconds part of a specified datetime:
SELECT
Second(#24/10/2016 11:18:34 PM#);Try it Yourself »
❮ MS Access Functions
