Merge 1 or 2 columns creating a time interval for each row. Values of the columns will be expected as dates in the given date format
Only one of the 2 column could be null, and its corresponding start/end default will be used.
Columns can be of any type.
Default start and end values will be used when the columns don't have a value or it can't be parsed to a date. If a default value can't be parsed to a date, infinity will be used as default instead.
When start > end for any reason:
- If both columns were provided: A infinite time interval will be set
- If only one column was provided: The value for the provided column will be kept and the other will be infinite
@param table Table of the columns, can't be null or wrong
@param startColumn Column to use as start value
@param endColumn Column to use as end value
@param dateFormat Format for the dates, can't be null
@param defaultStartDate Default date to use as start if it can be parsed
@param defaultEndDate Default date to use as end if it can be parsed
@return Time interval column