Savant

<code>datetime</code>: The initial datetime value to which you want to apply the interval.

<code>number</code>: The numeric value representing the amount you want to add or subtract.

SECOND/MINUTE/HOUR: Specify the time unit (second, minute, or hour) for the interval.

1. <code>datetime</code>: The initial datetime value to which you want to apply the interval.
2. <code>number</code>: The numeric value representing the amount you want to add or subtract.
3. SECOND/MINUTE/HOUR: Specify the time unit (second, minute, or hour) for the interval.

Adds a specified number of seconds, minutes, or hours to a datetime

INTERVAL (DateTime)

Savant App

Savant Help

Find answers and get help from Intercom Support and Community Experts

Empty Help Center

Uh oh. That page doesn’t exist.

Disappointed

Neutral

Smiley

Title

Track the progress of all tickets related to your company.

Tickets portal.

{assigneeName} needs more information from you

Description	The `INTERVAL` function enables you to perform datetime arithmetic by adding or subtracting a specified number of seconds, minutes, or hours to a given datetime. This is useful for scheduling, time-based calculations, or event planning.
Syntax	`datetime` + INTERVAL `number` SECOND/MINUTE/HOUR
Output	datetime

Meeting	Start Time	INTERVAL
Team Meeting	2023-09-05T05:00:00000	2023-09-05T05:30:00000
Project Kickoff	2023-09-10T10:30:00000	2023-09-10T11:00:00000
Training	2023-09-15T06:00:00000	2023-09-15T06:30:00000

Meeting	Start Time	INTERVAL
Team Meeting	2023-09-05T05:00:00000	2023-09-05T05:00:15000
Project Kickoff	2023-09-10T10:30:00000	2023-09-10T10:30:15000
Training	2023-09-15T06:00:00000	2023-09-15T06:00:15000

Meeting	Start Time	INTERVAL
Team Meeting	2023-09-05T05:00:00000	2023-09-05T17:00:00000
Project Kickoff	2023-09-10T10:30:00000	2023-09-10T22:30:00000
Training	2023-09-15T06:00:00000	2023-09-15T18:00:00000

Example 1

Example 2

Example 3