Savant

Creates a date based on the provided year, month, and day values

DATE

Adds a specified offset of time (e.g., seconds, minutes, hours) to a given date or datetime

DATE_ADD

Calculates the difference in days, weeks, months, quarters, or years between two dates

DATE_DIFF

Creates a datetime based on the provided year, month, day, hour, minute, and second values

DATETIME

Retrieves the day of the month from a given date or datetime

Determines the day of the week for a given date or datetime, where Monday is 1, Tuesday is 2, and so on

DAY_OF_WEEK

Calculates the day of the year for a given date or datetime

DAY_OF_YEAR

Calculates the number of days in the month for a given date or datetime

DAYS_IN_MONTH

Calculates the number of days in a year for a given date or datetime, considering leap years

DAYS_IN_YEAR

Extracts the hour component from a given datetime

HOUR

Adds a specified number of days, weeks, months, quarters, or years to a date

INTERVAL (Date)

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

INTERVAL (DateTime)

Extracts the minute component from a given datetime

MINUTE

Retrieves the month component from a given date

MONTH

Retrieves the quarter of the year from a given date or datetime

QUARTER

Extracts the second component from a given datetime

SECOND

Returns a standard time period (e.g., day, week, month, quarter, year) for a given date or datetime field

TIME_PERIOD

Calculates the number of time periods between a given date and the current period

TIME_PERIOD_OFFSET

TODAY

Determines the week number of the year for a given date or datetime

WEEK/WEEK_OF_YEAR

Retrieves the year component from a given date or datetime

YEAR

Date and 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