The following time functions are supported. Valid values for
<timepart> vary, based on the Zoomdata connector selected, but can include YEAR, QUARTER, MONTH, WEEK, DAY, HOUR, MINUTE, SECOND, or MILLISECOND. Review the documentation for the Zoomdata connector for any deviations from this list.
In the following example, the day of the week is extracted:
EXTRACT (day, NOW())
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 value of a
Rounds (Truncates) the
In the following example, the current time is truncated to the day of the week:
TRUNCATE_TIME (day, NOW())
Was this topic helpful?