FormulaDescriptionCharacter Index/Position, ARJDBCThis function searches for one character expression inside a second character expression, returning the starting position of the first expression if found.Convert CLOB to Varchar (Oracle), ARJDBCThis function converts an expression of type CLOB to an expression of type Varchar.Convert nText to Varchar (MSSQL), ARJDBCThis function converts an expression of type nText to an expression of type Varchar.Convert String to Number, ARJDBCThis function converts an expression of type String to an expression of type Number.Current Date, ARJDBCThis function returns the current date and time. The date is returned in the DD/MM/YYYY format.Date Difference - In Days, ARJDBCThis function returns the difference between two date values, in days.Date Difference - In Seconds, ARJDBCThis function returns the difference between two date values, in seconds.Date, ARJDBCThis function returns the current system date.DateAdd, ARJDBC

This function adds a specified number value (as a signed integer) to a specified datepart of an input date value, and then returns that modified value.

Day, ARJDBCThis function returns the day of the month from a specified date.First Day of Month, ARJDBCThis function returns the day of the month.First Day of Quarter, ARJDBCThis function returns the day of the quarter.First Day of Year, ARJDBCThis function returns the day of the year.Hour, ARJDBCThis function returns the hour part of the specified time.Length, ARJDBCThis function returns the number of characters of an input string.List Aggregation, ARJDBCThis function transforms values from a group of rows into a list of values that are delimited by a configurable separator.Lower, ARJDBCThis function returns a character expression after converting uppercase character data to lowercase.LPAD, ARJDBCThis function left-pads a string with another string, to a specified length.LTRIM, ARJDBCThis function returns a character expression after removing the leading blanks from the specified string.Minute, ARJDBCThis function returns the minute part of the specified time.Month Name, ARJDBCThis function returns the name of the month from a specified date.Month Short Name, ARJDBCThis function returns the name of the month in short format from a specified date. Month, ARJDBC

This function returns an integer that represents the month of the specified date.

Quarter, ARJDBCThis function returns the quarter of the year for a specified date.Replace String, ARJDBCThis function replaces all occurrences of a specified string value with another string value.RPAD, ARJDBCThis function right-pads a string with another string, to a specified length.RTRIM, ARJDBCThis function returns a character expression after removing the trailing blanks from the specified string.Seconds, ARJDBCThis function returns the seconds part of the specified time.SubString, ARJDBCThis function returns part of a character for given length from start position.Upper, ARJDBCThis function returns a character expression after converting lowercase character data to uppercase.Week Day Name, ARJDBCThis function returns the weekday name for a specified date.Week, ARJDBCThis function returns an integer that represents the week number for a specified date.Weekday Number, ARJDBCThis function returns an integer that represents the weekday number for a specified date.Year, ARJDBCThis function returns an integer that represents the year of the specified date.