time_interval

The unit used to measure the duration of the intervals. Allowed unit specifiers are the codes and corresponding names in this table. If the full unit name is used, it can be spelled in any case as well as singular or plural. I.e. all of the following are equivalent: ‘D’, ‘day’, ‘days’, ‘Day’, ‘Days’

Values must be one of the following:

Y year Year years Years M month Month months Months W week Week weeks Weeks D day Day days Days h hour Hour hours Hours m minute Minute minutes Minutes s second Second seconds Seconds ms millisecond Millisecond milliseconds Milliseconds us microsecond Microsecond microseconds Microseconds ns nanosecond Nanosecond nanoseconds Nanoseconds ps picosecond Picosecond picoseconds Picoseconds fs femtosecond Femtosecond femtoseconds Femtoseconds as attosecond Attosecond attoseconds Attoseconds

Return type of interval duration. Whether the interval duration should always be returned as positive, independent of whether date1 occurred before or after date2.

Date start reference for intervals. If only one column is specified as input, a reference date relative to which the intervals will be calculated. The result will be date1 - since. I.e. intervals will be positive if dates in the column are more recent than the reference date (and negative otherwise). The date must be either be a valid date string (preferrable month-first, e.g. “2021-12-31”), or any of the constants “today”, “now”, “tomorrow”, “yesterday”.

Date ending reference for intervals. If only one column is specified as input, a reference date relative to which the intervals will be calculated. The result will be until - date1. I.e. intervals will be positive if the reference date is more recent than the dates in the column (and negative otherwise). The date must be either be a valid date string (preferrable month-first, e.g. “2021-12-31”), or any of the constants “today”, “now”, “tomorrow”, “yesterday”.