With every release, additional functions are added to Sybase IQ. Below is
a list of functions from version 15.2. We'd like to see LEAD and LAG
functions also .. these are presently only available in Sybase RAP.
ABS function [Numeric]
ACOS function [Numeric]
ATAN function [Numeric]
ATAN2 function [Numeric]
COS function [Numeric]
ARGN function [Miscellaneous]
ASCII function [String]
ASIN function [Numeric]
ATAN function [Numeric]
ATAN2 function [Numeric]
SIN function [Numeric]
ATAN function [Numeric]
ASIN function [Numeric]
ATAN2 function [Numeric]
TAN function [Numeric]
ATAN2 function [Numeric]
ASIN function [Numeric]
ATAN function [Numeric]
TAN function [Numeric]
AVG function [Aggregate]
SUM function [Aggregate]
BIGINTTOHEX function [Data type conversion]
HEXTOBIGINT function [Data type conversion]
HEXTOINT function [Data type conversion]
INTTOHEX function [Data type conversion]
BIT_LENGTH function [String]
BYTE_LENGTH function [String]
DATALENGTH function [System]
LENGTH function [String]
CAST function [Data type conversion]
CEIL function [Numeric]
CEILING function [Numeric]
CHAR function [String]
CHAR_LENGTH function [String]
CHARINDEX function [String]
COALESCE function [Miscellaneous]
COL_LENGTH function [System]
COL_NAME function [System]
OBJECT_ID function [System]
CONNECTION_PROPERTY function [System]
PROPERTY_NUMBER function [System]
CONVERT function [Data type conversion]
CORR function [Aggregate]
COS function [Numeric]
COT function [Numeric]
SIN function [Numeric]
TAN function [Numeric]
COT function [Numeric]
SIN function [Numeric]
TAN function [Numeric]
COVAR_POP function [Aggregate]
COVAR_SAMP function [Aggregate]
COUNT function [Aggregate]
SUM function [Aggregate]
CUME_DIST function [Ranking]
DATALENGTH function [System]
COL_LENGTH function [System]
DATE function [Date and time]
DATEADD function [Date and time]
DATECEILING function [Date and time]
DATEDIFF function [Date and time]
DATEFLOOR function [Date and time]
DATEFORMAT function [Date and time]
DATENAME function [Date and time]
DATEPART function [Date and time]
DATEROUND function [Date and time]
DATETIME function [Date and time]
DAY function [Date and time]
DAYNAME function [Date and time]
DAYS function [Date and time]
DB_ID function [System]
OBJECT_ID function [System]
DB_NAME function [System]
DB_ID function [System]
OBJECT_NAME function [System]
DB_PROPERTY function [System]
DB_ID function [System]
DB_NAME function [System]
DEGREES function [Numeric]
DENSE_RANK function [Analytical]
RANK function [Analytical]
DIFFERENCE function [String]
DOW function [Date and time]
ERRORMSG function [Miscellaneous]
EVENT_CONDITION function [System]
EVENT_CONDITION_NAME function [System]
EVENT_PARAMETER function [System]
EXP function [Numeric]
EXP_WEIGHTED_AVG function [Aggregate]
FIRST_VALUE function [Aggregate]
FLOOR function [Numeric]
GETDATE function [Date and time]
GRAPHICAL_PLAN function [String]
PLAN function [Miscellaneous], EXPLANATION function, [Miscellaneous]
GRAPHICAL_ULPLAN function [Miscellaneous], LONG_ULPLAN, SHORT_ULPLAN
GROUPING function [Aggregate]
GROUP_MEMBER function [System]
HEXTOBIGINT function [Data type conversion]
BIGINTTOHEX function [Data type conversion]
HEXTOINT function [Data type conversion]
INTTOHEX function [Data type conversion]
HEXTOINT function [Data type conversion]
INTTOHEX function [Data type conversion]
HOUR function [Date and time]
HOURS function [Date and time]
HTML_DECODE function [HTTP]
HTTP_ENCODE function [HTTP]
HTML_ENCODE function [HTTP]
HTTP_ENCODE function [HTTP]
HTML_PLAN function [String]
PLAN function [Miscellaneous], EXPLANATION function, [Miscellaneous],
GRAPHICAL_ULPLAN function [Miscellaneous], LONG_ULPLAN, and SHORT_ULPLAN
HTTP_DECODE function [HTTP]
HTTP_ENCODE function [HTTP]
HTTP_ENCODE function [HTTP]
HTTP_DECODE function [HTTP]
HTTP_HEADER function [HTTP]
NEXT_HTTP_HEADER function [HTTP]
NEXT_HTTP_VARIABLE function [HTTP]
HTTP_VARIABLE function [HTTP]
HTML_DECODE function [HTTP]
NEXT_HTTP_HEADER function [HTTP]
NEXT_HTTP_VARIABLE function [HTTP]
IFNULL function [Miscellaneous]
INDEX_COL function [System]
INSERTSTR function [String]
INTTOHEX function [Data type conversion]
HEXTOINT function [Data type conversion]
ISDATE function [Date and time]
ISNULL function [Miscellaneous]
ISNUMERIC function [Miscellaneous]
LAST_VALUE function [Aggregate]
LCASE function [String]
UCASE function [String]
UPPER function [String]
LEFT function [String]
LEN function [String]
CHAR_LENGTH function [String]
STR_REPLACE function [String]
LENGTH function [String]
CHAR_LENGTH function [String]
LN function [Numeric]
LOCATE function [String]
LOG function [Numeric]
LOG10 function [Numeric]
LOWER function [String]
UCASE function [String]
UPPER function [String]
LTRIM function [String]
TRIM function [String]
MAX function [Aggregate]
MEDIAN function [Aggregate]
MIN function [Aggregate]
MINUTE function [Date and time]
MINUTES function [Date and time]
MOD function [Numeric]
MONTH function [Date and time]
MONTHNAME function [Date and time]
MONTHS function [Date and time]
NEWID function [Miscellaneous]
UUIDTOSTR function [String]
NEXT_CONNECTION function [System]
NEXT_DATABASE function [System]
NEXT_HTTP_HEADER function [HTTP]
NEXT_HTTP_VARIABLE function [HTTP]
HTTP_VARIABLE function [HTTP]
NEXT_HTTP_HEADER function [HTTP]
NOW function [Date and time]
NTILE function [Analytical]
NULLIF function [Miscellaneous]
NUMBER function [Miscellaneous]
OBJECT_ID function [System]
DB_ID function [System]
OBJECT_NAME function [System]
OBJECT_NAME function [System]
DB_NAME function [System]
OBJECT_ID function [System]
OCTET_LENGTH function [String]
PATINDEX function [String]
LOCATE function [String]
PERCENT_RANK function [Analytical]
PERCENTILE_CONT function [Analytical]
NTILE function [Analytical]
PERCENTILE_DISC function [Analytical]
PERCENTILE_DISC function [Analytical]
NTILE function [Analytical]
PERCENTILE_CONT function [Analytical]
PI function [Numeric]
POWER function [Numeric]
PROPERTY function [System]
PROPERTY_DESCRIPTION function [System]
PROPERTY_NAME function [System]
PROPERTY_NUMBER function [System]
QUARTER function [Date and time]
RADIANS function [Numeric]
RAND function [Numeric]
RANK function [Analytical]
DENSE_RANK function [Analytical]
REGR_AVGX function [Aggregate]
REGR_AVGY function [Aggregate]
REGR_COUNT function [Aggregate]
REGR_INTERCEPT function [Aggregate]
REGR_R2 function [Aggregate]
REGR_SLOPE function [Aggregate]
REGR_SXX function [Aggregate]
REGR_SXY function [Aggregate]
REGR_SYY function [Aggregate]
REMAINDER function [Numeric]
REPEAT function [String]
REPLACE function [String]
REPLICATE function [String]
REVERSE function [String]
RIGHT function [String]
ROUND function [Numeric]
ROWID function [Miscellaneous]
RTRIM function [String]
SECOND function [Date and time]
SECONDS function [Date and time]
SIGN function [Numeric]
SIMILAR function [String]
SIN function [Numeric]
COS function [Numeric]
COT function [Numeric]
TAN function [Numeric]
SORTKEY function [String]
SOUNDEX function [String]
SPACE function [String]
SQRT function [Numeric]
SQUARE function [Numeric]
STDDEV function [Aggregate]
VARIANCE function [Aggregate]
STDDEV_POP function [Aggregate]
STDDEV_SAMP function [Aggregate]
STDDEV function [Aggregate]
STR function [String]
STR_REPLACE function [String]
Function LENGTH function [String] .
STRING function [String]
STRTOUUID function [String]
UUIDTOSTR function [String]
STUFF function [String]
SUBSTRING function [String]
SUM function [Aggregate]
COUNT function [Aggregate]
SUSER_ID function [System]
USER_ID function [System]
SUSER_NAME function [System]
USER_NAME function [System]
TAN function [Numeric]
SIN function [Numeric]
TODAY function [Date and time]
TRIM function [String]
RTRIM function [String]
TRUNCNUM function [Numeric]
TS_ARMA_AR function [Time Series]
TS_ARMA_CONST function [Time Series]
TS_ARMA_MA function [Time Series]
TS_AUTOCORRELATION function [Time Series]
TS_AUTO_UNI_AR function [Time Series]
TS_BOX_COX_XFORM function [Time Series]
TS_DIFFERENCE function [Time Series]
TS_ESTIMATE_MISSING function [Time Series]
TS_LACK OF FIT function [Time Series]
TS_LACK OF FIT_P function [Time Series]
identical to TS_LACK OF FIT function [Time Series] , except
TS_MAX_ARMA_AR function [Time Series]
TS_MAX_ARMA_CONST function [Time Series]
TS_MAX_ARMA_LIKELIHOOD function [Time Series]
TS_MAX_ARMA_MA function [Time Series]
TS_OUTLIER_IDENTIFICATION function [Time Series]
TS_PARTIAL_AUTOCORRELATION function [Time Series]
TS_VWAP function [Time Series]
UCASE function [String]
UPPER function [String]
UPPER function [String]
LOWER function [String]
UCASE function [String]
USER_ID function [System]
USER_NAME function [System]
USER_NAME function [System]
USER_ID function [System]
UUIDTOSTR function [String]
STRTOUUID function [String]
VAR_POP function [Aggregate]
VAR_SAMP function [Aggregate]
VARIANCE function [Aggregate]
VARIANCE function [Aggregate]
VAR_SAMP function [Aggregate]
WEEKS function [Date and time]
WEIGHTED_AVG function [Aggregate]
WIDTH_BUCKET function [Numerical]
YEAR function [Date and time]
YEARS function [Date and time]
YMD function [Date and time]
|
|
