Date & Time
Usage
A Date & Time filter is a UI control for selecting an instant in time.
A date-time filter is used in a condition on a SQL date-time expression.
{[<date_time_expr>]=<filter_variable_name>}
The <date_time_expr>
must either be an expression of type TIMESTAMP
(or a
database-specific equivalent) or an expression that can be cast to a
TIMESTAMP
. The filter input value that the expression is compared to is always
generated by Cluvio as a database-specific date-time literal, as in TIMESTAMP '2023-04-12T10:58:12'
. For example, the following parameterised SQL query
SELECT *
FROM logs
WHERE {log_timestamp=my_date_time_filter}
with a selected input timestamp of 2023-04-12T10:58:12
results in database-specific
SQL similar to the following:
SELECT *
FROM logs
WHERE log_timestamp = TIMESTAMP '2023-04-12T10:58:12'
A Date & Time filter only creates date-time equality conditions in SQL. For filtering date-time ranges, see the Date & Time Range filter instead.
Configuration
To configure a Date & Time
filter, select the Date / Time
UI control type in
the filter definition dialog.
Use the Configuration
tab to set a default value and further configuration
options.
Value Selectors
A value selector allows to tap into SQL value expressions associated with the selected date & time.
Date-Time Value
SELECT {my_date_time.value}
The .value
selector produces a database-specific date-time value expression or
NULL
if no value is selected.
Selected
SELECT *
FROM event
WHERE
CASE
WHEN {my_date_time.selected} = TRUE THEN {starttime=my_date_time}
ELSE starttime = TIMESTAMP '2024-01-01T00:00:00'
END
The .selected
selector produces a database-specific boolean expression that is
true
when a value is selected for the filter, false
otherwise.