The SECONDS function converts the time value in HH:MM:SS format into the equivalent number of seconds that the time represents.
Category
Date / Time
Syntax
SECONDS(time)
Parameter and Description
| Parameter | Description |
|---|---|
| time | A time value in HH:MM:SS or HHMMSS format. This value can be a source field, a constant, a variable or the result of another Function. |
Example
Convert the time value 10:15:24am to seconds and map the result to target field TGT_SECONDS.
TGT_SECONDS = SECONDS('10:15:24')
Returns the value 36,294 and maps the result to the target field.