ShowScalarFunctions

Table of Contents



Lists the built-in scalar functions with their parameters and descriptions.

ShowScalarFunctions()

Name, ReturnType, Parameters and Description. Each prototype is also returned as a message.

round-pushpin Lists the scalar functions.
EXEC ShowScalarFunctions




SQL :: Concat
Concatenates all of the given values that are not null. Accepts any number of values. The + operator can also be used to concatenate, but a null on either side of + makes the whole result null.
SQL :: DateAdd
Adds offset intervals to a date/time value and returns the new date/time. Use a negative offset to subtract. Interval names are not case-sensitive.
SQL :: DateDiff
Returns the number of intervals between two date/time values (date2 minus date1). See DateAdd for the interval names.
SQL :: DateTime
Returns the server's current local date and time, formatted with the optional .NET date/time format string.
SQL :: DateTimeUTC
Returns the current UTC date and time, formatted with the optional .NET date/time format string. See DateTime for the format specifiers.
SQL :: Exec
Exec runs a system procedure.
SQL :: Expressions
Literals, operators, comments and variables in KBSQL.
SQL :: Floor
Returns the largest whole number that is less than or equal to the given number.
SQL :: FormatDateTime
Parses a date/time value and returns it formatted with a .NET date/time format string. See DateTime for the format specifiers.
SQL :: FormatNumeric
Formats a number using a .NET numeric format string and returns the result as text.