SECONDS - connect_cdc_sqdata - Latest

Connect CDC (SQData) Apply engine

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
ft:locale
en-US
Product name
Connect CDC (SQData)
ft:title
Connect CDC (SQData) Apply engine
Copyright
2025
First publish date
2000
ft:lastEdition
2025-03-03
ft:lastPublication
2025-03-03T15:29:41.860000

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.