The following time functions are supported. Valid values for
<timepart> vary, based on the Composer connector selected, but can include YEAR, QUARTER, MONTH, WEEK, WEEK_OF_YEAR, WEEK_OF_MONTH, DAY, DAY_OF_YEAR, DAY_OF_MONTH, DAY_OF_WEEK, HOUR, MINUTE, SECOND, or MILLISECOND. Review the documentation for the Composer connector for any deviations from this list. Note that the WEEK_OF_YEAR function calculates the week from January 1, not from the week containing January 1.
Obtains the current date and time for the derived field. However,
CASE WHEN [date column] = ''
Adds an interval value to the
time_add(<timepart>, <interval>, <datetime>)
In the following example, 7 is added to the hour in the field called
TIME_ADD (hour, +7, date_time_field)
Returns the time difference between two time fields in the unit you request:
time_diff('<timepart>', <end_date_field>, <start_date_field>)
In the following example, the difference between the values of the ENDDATE and STARTDATE fields is returned in days:
time_diff('DAY', ENDDATE, STARTDATE)
Returns the value of a
Rounds (Truncates) the