Skip to main content
Savant App
Savant Help
English
English
Savant App
Savant Help
English
English
Search for articles...
All Collections
Tools and Functions
Functions Overview
Functions Overview
Build your perfect analysis with Savant's powerful and intuitive functions
97 articles
Functions
Operators
Date and DateTime
DATE
DATE_ADD
DATE_DIFF
DATETIME
DAY
DAY_OF_WEEK
DAY_OF_YEAR
DAYS_IN_MONTH
DAYS_IN_YEAR
HOUR
INTERVAL (Date)
INTERVAL (DateTime)
MINUTE
MONTH
NOW
QUARTER
SECOND
TIME_PERIOD
TIME_PERIOD_OFFSET
TODAY
WEEK/WEEK_OF_YEAR
YEAR
Formatting
TO_BOOLEAN
TO_DATE
TO_DATETIME
TO_INTEGER
TO_NUMBER
TO_TEXT
Keywords
CASE ... WHEN ...
IN
Logical
IF
IFS
Math
ABS
CEILING
FLOOR
GREATEST
LEAST
LOG
MOD
POWER
RANDOM
ROUND
ROUNDDOWN
ROUNDUP
Multi-Row Aggregation & Windowing
AVG
CONCAT
CONCAT DISTINCT
COUNT
COUNT DISTINCT
CUMULATIVE SUM
FILL
FIRST
LAG
LAST
LEAD
MAX
MEDIAN
MIN
NTILE
RANK
ROW NUMBER
STDDEV
SUM
VAR
Text
COALESCE
CONCAT
CONTAINS
FIRST_NOT_EMPTY
HASH
HTML_ESCAPE
IS_EMPTY
JSON_FIELD
JSON_SET
JWT_ENCODE
LEFT_PART
LENGTH
LEVENSHTEIN
LOWER
MID
PAD_LEFT
PAD_RIGHT
PROPER
REGEX_EXTRACT
REGEX_MATCH
REGEX_REPLACE
REGEX_SEARCH
REPEAT()
REPLACE
REVERSE
RIGHT_PART
SEARCH
SOUNDEX
SPLIT_PART
UNESCAPE_HTML
UPPER