SETTIME

SETTIME(date, time)

Combines a date and a time into a single datetime value.

The SETTIME function constructs a DATETIME formula by combining the provided date with the specified time. If any input is an array, the function will operate element-wise and produce a DATETIME_ARRAY.

Parameters:

• date (Operand) –

  The date component. Can be a scalar date or DATE_ARRAY.

  Supported types:

  • DATE

  • DATE_ARRAY

  • DATETIME

  • DATETIME_ARRAY

• time (Operand) –

  The time component.

  Supported types:

  • TIME

  • DATETIME

  • TIME_ARRAY

  • DATETIME_ARRAY

Return type:

Formula

Returns:

A Formula object representing the combined date and time. Returns an array if any input is an array; otherwise, a scalar DATETIME.

Supported types:

• DATETIME

• DATETIME_ARRAY

Raises:

• ValueError – If the date is not of type DATE/DATE_ARRAY/DATETIME/DATETIME_ARRAY or

• time –

Examples

SETTIME(DATE(2025, 9, 3), TIME(14, 30, 0))
# Returns a DATETIME representing 2025-09-03 14:30:00