SETTIME

SETTIME(date, time)[source]

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.

  • time (Operand) – The time component.

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.

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

``date`` — accepted types

  • DATE

  • DATETIME

  • DATETIME_ARRAY

  • DATE_ARRAY

``time`` — accepted types

  • DATETIME

  • DATETIME_ARRAY

  • TIME

  • TIME_ARRAY

Return types

  • DATETIME

  • DATETIME_ARRAY