SECOND

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