![SECOND]({"bg": "//theme.zdassets.com/theme_assets/9691885/e106cc8a79a6a41c781c71d999cffaa33b481de7.jpg"})
![SECOND]({"bg": "//theme.zdassets.com/theme_assets/9691885/d38d9cc5a4fcb160800cb7a8f0e0cb60aaa36d2e.jpg"})
The function SECOND returns the value of the second in a Time or DateTime.
This function takes input in the form of either a Time or a DateTime. It returns a Number: the value of the second in the given Time or a DateTime.
Declaration
SECOND(datetime) -> second
SECOND(time) -> second
Parameters
- datetime (type: DateTime)
- Any DateTime.
- This is what describes the second value that the SECOND function will return.
- time (type: Time)
- Any Time.
- This is what describes the second value that the SECOND function will return.
Return Values
- second (type: Number)
- The second value from the given Time or DateTime.
Examples
Assume the first example has access to the following DateTime value:
example_date_and_time = {
"date": {
"day": 1,
"month": 4,
"year": 2021
},
"time": {
"hour": 16,
"minute": 14,
"second": 38,
"millisecond": 0
},
"timeZone": "UTC"
}
The following example takes the time described in example_date_and_time and outputs the number of seconds described:
SECOND(example_date_and_time) = 38
The above example demonstrates how the SECOND function behaves when given a DateTime as input. In order to further establish how the SECOND function behaves when given a Time as input, assume the last example has access to the following Time value:
example_time = {
"hour": 16,
"minute": 14,
"second": 38,
"millisecond": 0
}
The following example takes the time described in example_time and outputs the number of seconds described:
SECOND(example_time) = 38
0
0
Was this article helpful?
0 out of 0 found this helpful