6 Functions 🧮
SQL expressions can utilize a myriad of functions alongside field values and constants. Each function needs a set number of 'arguments' and yields one value.
6.1 Aggregate functions 📊
Refer to Section 10.3 for details.
6.2 Date functions 📆
YEARPART 📅
YEARPART(date)
- Retrieves the year of the date.MONTHPART 📆
MONTHPART(date)
- Determines the month of the date.DAYPART 🌞
DAYPART(date)
- Extracts the day from the date.DATEPART 🗓
DATEPART(date)
- Provides the date while removing minutes.TIMEPART ⌚
TIMEPART(date)
- Gives the time in minutes from the date.YEARMONTHPART 📅📆
YEARMONTHPART(date)
- Shows year and month as a string.MONTHYEARPART 📆📅
MONTHYEARPART(date)
- Displays month and year in a string format.MONTHNAME 📆
MONTHNAME(date)
- Returns the full month name.SHORTMONTHNAME 🗓
SHORTMONTHNAME(date)
- Gives the abbreviated month name.DAYNAME 🌞
DAYNAME(date)
- Fetches the full day name.SHORTDAYNAME 🌤
SHORTDAYNAME(date)
- Offers the abbreviated day name.NOW 🕰
NOW()
- Provides the current date and time.YEARSDIFF 📅⏳
YEARSDIFF(from,to)
- Calculates the year difference between two dates.MONTHSDIFF 📆⏳
MONTHSDIFF(from,to)
- Determines the month difference between two dates.DAYSDIFF 🌞⏳
DAYSDIFF(from,to)
- Measures the day difference between two dates.
... and many more!
6.3 List variable functions 📝
Refer to the List Variables section for more details.
6.4 Trigonometric and logarithmic functions 📐📈
Covers functions related to angles and logs. Includes functions like ACOS
, ASIN
, ATAN
, LOG
, and more.
6.5 String manipulation 🎻
Delves into manipulating strings with functions like LEN
, LEFT
, RIGHT
, MID
, SUBST
, etc.
6.6 Number conversion and formatting 🔢
Functions like FIXED
help in formatting numbers.
6.7 Numerical functions 🔢🔍
Includes functions such as ABS
, INT
, FLOOR
, CEIL
and more for number operations.
6.7 Conditional expression 🔄
IIF
and NVL
functions that help in setting conditions in SQL expressions.