Function Description
| Category | Description |
|---|---|
| Syntax | SECOND(time) |
| Function | Returns the second value from a specified time. |
| Parameter | time: a specified time value Only date or datetime values are supported. |
| Number of Parameters | 1 |
| Parameter Type | Date or datetime |
| Return Value Type | Number from 0 to 59 |
Examples
| Formula | Result |
|---|---|
SECOND(TIME(8,1,2)) | 2 |
SECOND(TODATE("2000-01-01 09:03:04")) | 4 |
More Examples
For example, you can use SECOND to get the second value from Order Start Time.
