Package com.gigaspaces.query.sql.functions

Interface Summary

Interface	Description
SqlFunctionExecutionContext	Defines the arguments to be passed to an SqlFunction, generated for sqlFunction invocations.

Class Summary

Class	Description
AbsSqlFunction	Built in mathematical sql function to get absolute value of a parameter.
AppendSqlFunction	Built in string sql function to append any number of given string arguments.
CastSqlFunction	Casts a String into the wanted data object
CeilSqlFunction	Built in mathematical sql function to calculate the smallest integer value not less than the given argument.
CharLengthSqlFunction	Built in string sql function to calculate the length of the string, measured in characters.
ConcatSqlFunction	Built in string sql function to concatenate any number of given string arguments.
ContainsKeySqlFunction	Built in sql function to check if a map field contains some key
CurrentDateSqlFunction	Returns current date formatted
CurrentTimeSqlFunction	Returns current time formatted
DateAddSqlFunction	Adds a time/date interval to a date and then returns the date
DayNameSqlFunction	Returns day name
DayOfMonthSqlFunction	Returns day of month
DayOfWeekSqlFunction	Returns day of week
DayOfYearSqlFunction	Returns day of year
DivideSqlFunction	Returns the the subtraction of two objects
FloorSqlFunction	Built in mathematical sql function to get the largest integer value not greater than the given argument.
GetDateSqlFunction	Returns current date formatted
HourSqlFunction	Returns hour according to timestamp
InStrSqlFunction	Built in string sql function to get the position of the first occurrence of a substring in a string.
LeftSqlFunction	Returns a substring of a given string starting from the left
Like	This code was copied from org.apache.calcite.runtime.Like refer to it if any future changes are needed
LowerSqlFunction	Built in string sql function to change all characters of a given string to lowercase.
MinusSqlFunction	Returns the the subtraction of two objects
MinuteSqlFunction	Returns minute according to timestamp
ModSqlFunction	Built in mathematical sql function to perform modulo operation.
MonthNameSqlFunction	Returns month name according to timestamp
MonthSqlFunction	Returns month according to timestamp
MultiplySqlFunction	Returns the the subtraction of two objects
OdbcTimestampSqlFunction	Returns timestamp with time zone
PgGetExprSqlFunction	A system function that returns a decompiled source code of a Postgres expression.
PlusSqlFunction	Returns the the addition of two objects
QuarterSqlFunction	Returns quarter according to timestamp
RepeatSqlFunction	Concats a string to itself n times
ReplaceSqlFunction	Built in string sql function to replace matching subtring with other argument
RightSqlFunction	Returns a substring of a given string starting from the right
RoundSqlFunction	Built in mathematical sql function to round the argument to nearest Integer.
SecondSqlFunction	Returns seconds according to timestamp
SqlFunction	Defines a routine, to be use in SQLQuery context, that accepts arguments and performs an action on the stored object, such as a complex calculation.
StrposFunction	Returns the position of the character where the first occurrence of the substring appears in a string.
SubstringSqlFunction	Returns a substring of a given string
SubstrSqlFunction	Returns a substring of a given string
SysDateSqlFunction	Returns date and time
ToCharSqlFunction	Built in conversion sql function to convert Date or Number types to chars.
ToCharUtil	Emulates Oracle's TO_CHAR function.
ToNumberSqlFunction	Built in conversion sql function to convert string type to Number.
TruncSqlFunction
UnsupportedSqlFunction	An implementation of a function that is not supported by the backend.
UpperSqlFunction	Built in string sql function to change all characters of a given string to uppercase.
WeekSqlFunction	Returns week according to timestamp
YearSqlFunction	Returns year according to timestamp