SnowConvert AI - Sybase IQ - Built-in functions

Note

For more information about built-in functions and their Snowflake equivalents, also see Common built-in functions.

Built-in Functions

This section describes each SQL function individually. (Sybase SQL Language Reference Functions (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a531c50684f21015af65db434a6a1ab5.html?version=16.1.5.0&locale=en-US)).

SybaseSnowflake Equivalent
ABS (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a532439384f21015be5cb176f7ecbae4.html) ( numeric-expression)ABS ( numeric-expression)
ACOS (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a532c20484f21015a4a5f8c26e3af9c7.html) ( numeric-expression)ACOS ( numeric-expression)
ARGN (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a53342da84f21015892d9495d775376f.html) (integer-expression, expression [ , …] )None

Note: Snowflake does not contain a similar built-in function, a UDF might be created to emulate the Sybase behavior.
ASCII (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a533e3a684f21015a2a0af73e4a9ad1c.html) ( string-expression)ASCII ( numeric-expression)
ASIN (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a534668f84f2101599958685dfc4673b.html) ( numeric-expression)ASIN ( numeric-expression)
ATAN (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a534e83384f21015a17bd5947c1575b2.html) ( numeric-expression)ATAN ( numeric-expression)
ATAN2 (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5356c1b84f210159f68d03274510fe6.html) (numeric-expression, numeric-expression)ATAN2 ( numeric-expression, numeric-expression)
AVG (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a535f04784f2101590f89a693842c970.html) ( [DISTINCT] column-name) [OVER ...]AVG ( [DISTINCT] column-name) [OVER ...]
BFILE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5366ee684f21015b5b0e80fe42dc31f.html) ( file-name-expression, large-object-column )None

Note: Snowflake does not contain a similar built-in function.
BIGINTTOHEX (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5370dd584f21015a902e1868e059b79.html) (integer-expression)None

Note: Snowflake does not contain a similar built-in function.
BIT_LENGTH (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a537928a84f210158191ea44ca58ee8e.html) (large-object-column)BIT_LENGTH (string_or_binary)

Note: Snowflake doesn't use fractional bytes, so length is always calculated as 8 * OCTET_LENGTH.
BYTE_INSERTSTR (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/81f411c06ce21014834ca45160d818e3.html)( insert-position , source-string , insert-string )None

Note: Snowflake does not contain a similar built-in function.
BYTE_LENGTH64 (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a538947b84f21015b13989839189a494.html)(large-object-column)None

Note: Snowflake does not contain a similar built-in function.
BYTE_LENGTH (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a53816b784f210159b849878d71ab1a8.html)(string-expression)None

Note: Snowflake does not contain a similar built-in function.
CAST (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a53996d784f21015a34086a244c40db1.html) (expression AS data type)CAST(source_expr AS target_data_type)
CEIL (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a53a419c84f21015b689e542cbf26996.html) (numeric-expression)CEIL( input_expr [, scale_expr ] )
CHAR (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a53b50f084f210159a74ba4e4e50f914.html) (integer-expression)CHAR (integer-expression)
CHAR_LENGTH (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a53bd3d384f21015bcf88da636a1a768.html) (string-expression)LENGTH (string or binary-expression)
CHAR_LENGTH64 (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a53c545784f21015bc94cb2f1bd99abc.html)(long-varchar-expression)LENGTH (string or binary-expression)
CHARINDEX (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a53cde2984f210158cbd968731b1879c.html)(string-expression1, string-expression2)CHARINDEXstring-expression1, string-expression2. [start-pos])
COALESCE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a53d627984f21015a1fa9a5eb36a5dde.html) (expression, expression, [...])COALESCE (expression, expression, [...])
COL_LENGTH (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a53de5ea84f21015b906dcfb2dc6b447.html) (table-name, column-name)None

Note: Snowflake does not contain a similar built-in function.
COL_NAME (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a53e665984f21015b7c5d3e09dd1397a.html)(table-id, column-id [, database-id]) None

Note: Snowflake does not contain a similar built-in function.
CONNECTION_PROPERTY (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a53eeaf984f21015974f97e3388d1738.html)( { integer-expression1 | string-expression } … [ , integer-expression2 ] )None

Note: Snowflake does not contain a similar built-in function.
CONVERT (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a53f6efb84f21015af0e8594ce5cd68e.html)( data-type, expression [ , format-style ] )CAST(source_expr AS target_data_type)
CORR (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a53fefea84f21015a7ac9e118cc9795c.html)( dependent-expression, independent-expression ) [OVER ...]CORR( dependent-expression, independent-expression ) [OVER ...]
COS (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5406e3184f21015956e83d802a05631.html) ( numeric-expression)COS ( numeric-expression)
COT (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a540f97a84f21015bfc68a88c0565f03.html) ( numeric-expression)COT ( numeric-expression)
COVAR_POP (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a541901c84f21015b699cc40f6738ebc.html) ( dependent-expression, independent-expression ) [OVER ...]COVAR_POP ( dependent-expression, independent-expression ) [OVER ...]
COVAR_SAMP (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5420eb484f21015be7f881364efd165.html) ( dependent-expression, independent-expression ) [OVER ...]COVAR_SAMP ( dependent-expression, independent-expression ) [OVER ...]
COUNT (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a54290fd84f21015b7dddc9484de19d0.html)( * | expression | DISTINCT column-name ) [OVER ...]COUNT ( * | expression | DISTINCT column-name ) [OVER ...]
CUME_DIST (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a54314be84f210159603ce84a892876c.html) () [OVER ...]CUME_DIST [OVER ...]
DATE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a544131284f21015a70ed7c8e7db2f8b.html)(string-expression)DATE(string-expression, [format])
DATEADD (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5449deb84f210159a75e748a099539f.html)( date-part, numeric-expression, date-expression )DATEADD( date-part, numeric-expression, date-expression )
DATECEILING (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a545210684f21015bfabb0f3f2ce3eae.html) ( date-part, numeric-expression[, multiple-expression] )None

Note: Snowflake does not contain a similar built-in function.
DATEDIFF (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a545a63784f210158075c22cd6f85d3a.html)( date-part, date-expression1, date-expression2 )DATEDIFF ( date-part, date-expression1, date-expression2 )

Note: Transformation Needs Review.
DATEFLOOR (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5462b6184f21015a0c4efd06d244945.html) ( date-part, datetime-expression [, multiple-expression ] )None

Note: Pending Transformation.
DATENAME (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5472b7084f21015892b91f8f67b6ef9.html) ( date-part, date-expression )None

Note: Pending Transformation.
DATEPART (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a547b06f84f210158ab3bd499f292d99.html)( date-part, date-expression )None

Note: Pending Transformation.
DATEROUND (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5483a3f84f21015ba1087485982b02f.html)( date-part, datetime-expression [, multiple-expression ] )None

Note: Pending Transformation.
DATETIME (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a548c21f84f210158350cf2fab822610.html)( expression )TO_TIMESTAMP (expression)
DAY (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5493fe284f2101587fac052951c6f01.html)( date-expression )DAY( date-expression )
DAYNAME (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a549c43b84f21015a569d8e52c4af3f8.html)( date-expression )DAYNAME_UDF(date-expression )
DAYS (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a54a45b584f21015a4c2ab2c117fc738.html)( datetime-expression )
| ( datetime-expression, datetime-expression )
| ( datetime-expression, integer-expression )		DAYS_UDF( datetime-expression )
| ( datetime-expression, datetime-expression )
| ( datetime-expression, integer-expression )
DB_ID (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a54ac47c84f2101591f3cf37067c4ad5.html)( [ database-name ] )DB_ID_UDF

Note: Snowflake does not have any built-in function to emulate this behavior.
DB_NAME (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a54b690484f21015b21ebe23e239b7fb.html)( [ database-id ] )CURRENT_DATABASE( )
DB_PROPERTY (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a54c05bf84f210159e15ebbba6819ce4.html)( { property-id | property-name }
[ , { database-id | database-name } ] )		None

Note: Snowflake does not have any built-in function to emulate this behavior.
DEGREES (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a54c87d684f21015a9b9f518179a73ff.html)( numeric-expression )DEGREES( numeric-expression )
DENSE_RANK (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a54d078b84f21015b96984e51c0cb74a.html) () [OVER ...]DENSE_RANK () [OVER ...]
DIFFERENCE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a54d8aac84f210158ef283ad984de764.html)( string-expression1, string-expression2 )None

Note: Snowflake does not have any built-in function to emulate this behavior.
DOW (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a54e817784f21015bfbbc50ea9eaecba.html)( date-expression )DAYOFWEEK( date-expression )
ENCRYPT (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/81f72ceb6ce210149256a7523672a8bb.html)( string-expression , key [ , algorithm-format [ , initialization-vector ] ] )ENCRYPT( value_to_encrypt , passphrase , [ [ additional_authenticated_data , ] encryption_method ] )

Note: Pending Review
ERRORMSG (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a54f2ead84f210158668ce108de25460.html)( [ sqlstate | sqlcode ] )None

Note: Snowflake does not have any built-in function to emulate this behavior.
EXP (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a55131d984f21015966fac9e1cb19b02.html)(numeric-expression)EXP(numeric-expression)
EXP_WEIGHTED_AVG (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a551b4fb84f210158a07f463ff01b5e2.html)(expression, period-expression) [OVER ...]None

Note: Snowflake does not have any built-in function to emulate this behavior.
EXTRACT (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/5225b3c7a7c54e5ab49d6888dd756800.html)( date-part FROM timestamp-expression )EXTRACT( date-part FROM timestamp-expression )

Note: Pending Review
FIRST_VALUE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5523f3c84f21015aa0092a61fcc2714.html)FIRST_VALUE
FLOOR (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a552c1cc84f21015bfc3d6309d6785d6.html)(numeric-expression)FLOOR(numeric-expression)
GETDATE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a553449784f21015aba2a0fc3f4ce78c.html)()GETDATE()
HASH (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/81f88c0c6ce210149fbfd5e80df422c4.html)( expression [ , algorithm ] )HASH

Note: Pending Transformation
HEXTOBIGINT (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a55548d184f21015b2d58684e0bb094a.html)( hexadecimal-string )None

Note: Snowflake does not have any built-in function to emulate this behavior.
HEXTOINT (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a555d0f984f210158262871887ce5bc9.html)( hexadecimal-string )None

Note: Snowflake does not have any built-in function to emulate this behavior.
HOUR (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a55651ad84f210158eceac6470043938.html)( datetime-expression )HOUR( datetime-expression )
HOURS (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a556e14084f210158443b519970bb86d.html)( datetime-expression )
| ( datetime-expression, datetime-expression )
| ( datetime-expression, integer-expression )		HOURS_UDF( datetime-expression )
| ( datetime-expression, datetime-expression )
| ( datetime-expression, integer-expression )
HTML_DECODE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/81f8bbdd6ce21014a76ca7e38126b096.html)( string-expression )None

Note: Snowflake does not have any built-in function to emulate this behavior.
HTML_ENCODE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/81f8c4b16ce21014aa14a17df2f5d8b1.html)( string-expression )None

Note: Snowflake does not have any built-in function to emulate this behavior.
HTTP_DECODE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/81f8d6e36ce210148909b1cd1df91fc7.html)( string-expression )None

Note: Snowflake does not have any built-in function to emulate this behavior.
HTTP_ENCODE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/81f8df8c6ce21014969efaff4e96db5c.html)( string-expression )None

Note: Snowflake does not have any built-in function to emulate this behavior.
HTTP_HEADER (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/81f8e9406ce210149888f72003377b08.html)( header-field-name [ , instance ] )None

Note: Snowflake does not have any built-in function to emulate this behavior.
HTTP_RESPONSE_HEADER (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/81f8f31b6ce21014b2f9e1f931f49fcd.html)( header-field-name [ , instance ] )None

Note: Snowflake does not have any built-in function to emulate this behavior.
HTTP_VARIABLE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/81f8fd606ce21014a283ae906e71712f.html)( var-name [ , instance [ , attribute ] ] )None

Note: Snowflake does not have any built-in function to emulate this behavior.
IFNULL (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a557e29b84f21015b460f69ff0fed6da.html) ( expression1, expression2 [ , expression3 ] )IFNULL

Note:
Is transformed to
IFF(input is null, expression2, expression3) when the expression3 is present if not the third parameter will be NULL.
INSERTSTR (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a558efff84f210159092915333b9e6df.html)( numeric-expression, base_expr, insert_expr )INSERT( base_expr, pos, len, insert_expr )
INTTOHEX (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a55971e984f21015845192079b46b239.html)(integer-expression)None
ISDATE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a559f0f684f21015b95ee838e6da62dc.html)( string-expression )IS_DATE_UDF
ISNULL (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a55a73cd84f21015ae0b9236251e12e7.html)( expression, expression [ …, expression ] )COALESCE( expression, expression [ …, expression ] )
ISNUMERIC (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a55af5d284f21015867a9c978b63f5c1.html)( string-expression )IS_NUMERIC_UDF( string-expression )
LAG (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a55b772a84f2101583fef0038bcd8bb0.html)( value_expr [, offset [, default ] ] ) [OVER ...]LAG ( value_expr [, offset [, default ] ] ) [OVER ...]
LAST_VALUE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a55bfa7784f21015b86bd5dcfa28a6a5.html)(expression [IGNORE NULLS | RESPECT NULLS]) OVER ...LAST_VALUE(expression [IGNORE NULLS | RESPECT NULLS]) OVER ...
LCASE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a55c82d484f210158fe3bfeba4f0e0bd.html) ( string-expression )LOWER ( string-expression )
LEAD (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a55d051484f21015b82fe3d1795a7a94.html) ( value_expr [, offset [, default ] ] ) [OVER ...]LEAD ( value_expr [, offset [, default ] ] ) [OVER ...]
LEFT (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a55d883284f210158c5ec15e3e69239f.html)( string-expression, numeric-expression )LEFT( string-expression, numeric-expression )
LEN (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a55e08c884f210159d0cec6bce940d82.html)( string-expression )LENGTH( string-expression )
LENGTH (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a55ea65684f21015a60794ef54777c14.html)( string-expression )LENGTH( string-expression )

LIST (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a2984e5584f21015bddde2495874815d.html)

([ALL | DISTINCT] string-expresssion
[, 'delimiter-string']
[ORDER BY order-by-expression [ ASC | DESC ], ... ]
) [OVER ...]

LISTAGG

([ DISTINCT ] expr1
[, delimiter ] )
[ WITHIN GROUP ( orderby_clause ) ]
OVER ( [ PARTITION BY expr2 ] )

Note: ALL Keyword not supported in snowflake.

LN (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a55f245c84f21015b1f7fdabe2f902dc.html)(numeric-expression)LN(numeric-expression)
LOG (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a560332084f21015bf3b92161333e171.html)(numeric-expression)LN(numeric-expression)
LOG10 (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a560b1f984f210158a13cb8a24202e26.html)(numeric-expression)LOG(10, N)
LOWER (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a561324784f2101582439eaf6377b80b.html)( string-expression )LOWER( string-expression )
LPAD (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/7bf4b4293b56487bbabf9c2f3d01b364.html)( str, n [, pattern ] )LPAD( str, n [, pattern ] )
LTRIM (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a561eaf184f2101596bab303110c20fb.html)( string-expression, [ trim_character_set ] )LTRIM( string-expression, [ trim_character_set ] )

Note: Snowflake is case-sensitive by default and affects operations with strings.
MAX (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5626d6684f210158cafad316e131142.html) ([DISTINCT] column-name) [OVER ...]MAX (column-name) [OVER ...]

Note: Usage of the DISTINCT keyword does not affect the result.
MEDIAN (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a562edfc84f210159175c2831fabbd47.html) ( [ ALL | DISTINCT ] expression ) [OVER ...]MEDIAN ( expression ) [OVER ...]

Note: Usage of the ALL has no effect on the function since it counts all by default. The DISTINCT keyword is not supported.
MIN (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5638af584f210158d1fe90a3fb7c0ec.html) ([DISTINCT] column-name) [OVER ...]MIN ( expression ) [OVER ...]

Note: Usage of the DISTINCT keyword does not affect the result.
MINUTE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5640f2284f21015825db935889f60d9.html)( datetime-expression )MINUTE( datetime-expression )
MINUTES (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5648d4484f21015975efebd7ac03399.html)( datetime-expression )
| ( datetime-expression, datetime-expression )
| ( datetime-expression, integer-expression )		MINUTES_UDF( datetime-expression )
| ( datetime-expression, datetime-expression )
| ( datetime-expression, integer-expression )
MOD (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5650e7684f21015b1dcafaf320a4d00.html)( dividend, divisor )MOD( dividend, divisor )
MONTH (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a565928184f21015aecd84c01c4c2078.html)( date-expression )MONTH( date-expression )
MONTHNAME (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a566193184f2101587e8896021cbc6c7.html)( date-expression )MONTHNAME_UDF( date-expression )
MONTHS (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a566ced484f21015ad419bb64c76680c.html)( datetime-expression )
| ( datetime-expression, datetime-expression )
| ( datetime-expression, integer-expression )		MONTH_UDF( datetime-expression )
| ( datetime-expression, datetime-expression )
| ( datetime-expression, integer-expression )
NEWID (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a56756f884f2101589eefadf085512d9.html) ( )UUID_STRING( )
NEXT_CONNECTION (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a567dab684f21015b1ad9ffdb01bb91a.html)( { connection-id }, { database-id } )None

Note: Snowflake does not have any built-in function to emulate this behavior.
NEXT_HTTP_HEADER (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/81fa91566ce210149757da0cc8b98f41.html)( string-expression )None

Note: Snowflake does not have any built-in function to emulate this behavior.
NOW (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a568dfde84f210159d57b7ca3bb6ca84.html)( * )CURRENT_TIMESTAMP( )
NTILE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5695f3f84f21015a23ae9730b31eef2.html)
( expression1 )
OVER
(
ORDER BY expression2 [ ASC | DESC ]
)		NTILE ( constant_value )
OVER
(
[ PARTITION BY expr1 ]
ORDER BY expr2 [ { ASC | DESC } ]
)
NULLIF (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a569fd1184f210159b61c1d4823ce243.html)( expression1, expression2 )NULLIF( expression1, expression2 )
NUMBER (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a56a888784f21015bbaed2c2a214738e.html)( * )None

Note: Snowflake does not have any built-in function to emulate this behavior.
OBJECT_ID (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a56b078284f210158dec9fd05131e60d.html) ( object-name )OBJECT_ID_UDF
OBJECT_NAME (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a56b844884f21015ba6d84cedfda5d23.html) ( object-id [ , database-id ] )None

Note: Snowflake does not have any built-in function to emulate this behavior.
OCTET_LENGTH (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a56c053484f21015952de04bc4dab521.html)( string-expression )OCTET_LENGTH( string-expression )
PATINDEX (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a56c8f8684f210158653d0c858b0e559.html)( '%pattern%', string-expression )PATINDEX_UDF( '%pattern%', string-expression )
PERCENT_RANK (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a56d183584f21015881bb3f46bb765ee.html) ( )
OVER
( ORDER BY expression [ ASC | DESC ] )		PERCENT_RANK ( )
OVER
(
[ PARTITION BY expr1 ]
ORDER BY expr2 [ { ASC | DESC } ]
[ fixedRangeFrame ]
)
PERCENTILE_CONT (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a56d9fa784f21015b6c8d94588153331.html) ( expression1 )
WITHIN GROUP
( ORDER BY expression2 [ ASC | DESC ] )		PERCENTILE_CONT ( percentile )
WITHIN GROUP (ORDER BY order_by_expr)
OVER ( [ PARTITION BY expr3 ] )
PERCENTILE_DISC (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a56e219484f21015b3a4f46749d3faf5.html) ( expression1> )
WITHIN GROUP ( ORDER BY expression2> [ ASC | DESC ] )		PERCENTILE_DISC ( percentile )
WITHIN GROUP (ORDER BY order_by_expr )
OVER ( [ PARTITION BY expr3 ] )
PI (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a56ea16284f21015b398e51fb08558f3.html) ( * )PI ( )
POWER (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a56f22b284f210159c928a9db0c5907e.html) ( numeric-expression1, numeric-expression2 )POWER ( numeric-expression1, numeric-expression2 )
PROPERTY (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a56fa4db84f2101581d1eea9ca3957e2.html) ( { property-id | property-name } )None

Note: Snowflake does not have any built-in function to emulate this behavior.
PROPERTY_DESCRIPTION (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a57024b884f21015a1819d79e3571f53.html) ( { property-id | property-name } )None

Note: Snowflake does not have any built-in function to emulate this behavior.
PROPERTY_IS_TRACKABLE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/65b794ca66ab4b7fb8e60b888f9fc1f4.html) ( property-id )None

Note: Snowflake does not have any built-in function to emulate this behavior.
PROPERTY_NAME (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a570a7e184f2101584578b1e641ba61b.html) ( property-id )None

Note: Snowflake does not have any built-in function to emulate this behavior.
PROPERTY_NUMBER (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a57131a184f2101585959e45321b1e95.html)None

Note: Snowflake does not have any built-in function to emulate this behavior.
QUARTER (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a571b27b84f21015b649cee091ad3bd6.html) ( date-expression )QUARTER ( date-expression )
QUARTERSTR (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/8fbd6b73408a49d1aa5c88d99954bf7c.html) ( date-expression,[ quarter_start_month ] )None

Note: Snowflake does not have any built-in function to emulate this behavior.
RADIANS (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a572340384f21015b1d3dab0d7a76062.html) (numeric-expression)RADIANS (numeric-expression)
RAND (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a572b2db84f210159574b044cfd9dcb6.html) ( [ integer-expression ] )RANDOM ( [ integer-expression ] )
RANK (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a57337e084f21015aa46b31299b91d70.html) ( )
OVER
(
[ PARTITION BY ]
ORDER BY expression [ ASC | DESC ]
)		RANK ( )
OVER
(
[ PARTITION BY ]
ORDER BY expression [ { ASC | DESC } ]
[ window_frame ]
)
READ_SERVER_FILE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/81fb732a6ce21014b442b1082d0be5af.html) ( filename [ , start [ , length ] ] )None

Note: Snowflake does not have any built-in function to emulate this behavior.
REGR_AVGX (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a573b70d84f21015a55f85bddd70d598.html) ( dependent-expression, independent-expression ) [OVER ...]REGR_AVGX ( dependent-expression, independent-expression ) [OVER ...]
REGR_AVGY (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a574426e84f210159d5d8adecd1f70f2.html) ( dependent-expression, independent-expression ) [OVER ...]REGR_AVGY ( dependent-expression, independent-expression ) [OVER ...]
REGR_COUNT (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a574c56884f21015b7b6f6bde76a2e6a.html) ( dependent-expression, independent-expression ) [OVER ...]REGR_COUNT ( dependent-expression, independent-expression ) [OVER ...]
REGR_INTERCEPT (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a57548bd84f21015a72397703df578ba.html) ( dependent-expression, independent-expression ) [OVER ...]REGR_INTERCEPT ( dependent-expression, independent-expression ) [OVER ...]
REGR_R2 (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a575c77684f210158d23e68bbd456148.html) ( dependent-expression, independent-expression ) [OVER ...]REGR_R2 ( dependent-expression, independent-expression ) [OVER ...]
REGR_SLOPE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a57647a684f21015af3cb26e82eae9cd.html) ( dependent-expression, independent-expression ) [OVER ...]REGR_SLOPE ( dependent-expression, independent-expression ) [OVER ...]
REGR_SXX (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a576c83284f21015b9d5bbf81742e83a.html) ( dependent-expression, independent-expression ) [OVER ...]REGR_SXX ( dependent-expression, independent-expression ) [OVER ...]
REGR_SXY (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a57748fd84f21015bfd08e9110638b53.html) ( dependent-expression, independent-expression ) [OVER ...]REGR_SXY ( dependent-expression, independent-expression ) [OVER ...]
REGR_SYY (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a57806cb84f21015933dc43a04d2cc9f.html) ( dependent-expression, independent-expression ) [OVER ...]REGR_SYY ( dependent-expression, independent-expression ) [OVER ...]
REMAINDER (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5788e7284f21015a4caecc7b2f96b10.html) ( dividend, divisor )MOD( dividend, divisor )
REPEAT (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a579104184f2101598d4cd02edf61346.html) ( string-expression, integer-expression )REPEAT( string-expression, integer-expression )
REPLACE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a579952184f210159e17940c17a6d8f7.html)( original-string, search-string, replace-string )REPLACE( original-string, search-string, replace-string )
REPLICATE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a57a156384f2101597df9d785635d3b0.html)( string-expression, integer-expression )REPEAT( string-expression, integer-expression )
REVERSE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a57a972e84f2101584c3b9d17a08b0f9.html) ( expression )REVERSE ( expression )
RIGHT (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a57b364f84f210158a90b2b566be1d36.html) ( string-expression, numeric-expression )RIGHT ( string-expression, numeric-expression )
ROUND (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a57bbb0684f21015822ddb659e37c042.html) ( numeric-expression, integer-expression )ROUND ( numeric-expression, integer-expression )
ROW_NUMBER (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a57c3ea884f21015b4f8c850a5a5357f.html) OVER ( [ PARTITION BY window partition ] ORDER BY window ordering )ROW_NUMBER OVER ( [ PARTITION BY window partition ] ORDER BY window ordering )
ROWID (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a57cbfb484f21015b1a6f34fe17463d2.html)( table-name)None

Note: Snowflake does not have any built-in function to emulate this behavior.
RPAD (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/3a8714b7782a4730b091194c3b54aca0.html)( str, n [, pattern ] )RPAD( str, n [, pattern ] )
RTRIM (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a57d411084f21015969acd7d63bcc34c.html) ( string-expression, [ trim_character_set ] )

RTRIM( string-expression, [ trim_character_set ] )

Note: Snowflake is case-sensitive

SECOND (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a57dc03b84f210158836c9258c67e700.html)( datetime-expression )SECOND( datetime-expression )
SECONDS (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a57e4e7d84f21015bdabf289394cd2ce.html)( datetime-expression )
| ( datetime-expression, datetime-expression )
| ( datetime-expression, integer-expression )		SECONDS_UDF( datetime-expression )
| ( datetime-expression, datetime-expression )
| ( datetime-expression, integer-expression )
SIGN (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a57ed58c84f21015bb5e803787dd27eb.html) (numeric-expression)SIGN (numeric-expression)
SIMILAR (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a57f56c484f21015b142b043da48dee3.html) ( string-expression1, string-expression2 )

None

Note: Snowflake does not have any built-in function to emulate this behavior.

SIN (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a57fd70a84f21015a70cd54791443340.html) (numeric-expression)SIN (numeric-expression)
SORTKEY (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5805ddb84f2101591ffe19db63f3521.html) ( string-expression [, { collation-id
| collation-name [ ( collation-tailoring-string ) ] } ] )		None

Note: Snowflake does not have any built-in function to emulate this behavior.
SOUNDEX (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a580dde084f21015b422a82fcc67a159.html)( string-expression )SOUNDEX( string-expression )
SPACE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5815e2c84f210158cf48f3c618df22c.html)(numeric-expression)SPACE(numeric-expression)
SQLFLAGGER (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a581e75f84f210158c3cd3ba6b97a9eb.html)( sql-standard-string, sql-statement-string )None

Note: Snowflake does not have any built-in function to emulate this behavior.
SQRT (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5826d0c84f210159ad8a785b1b1ac0b.html) (numeric-expression)SQRT (numeric-expression)
SQUARE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a582f08784f210158c9aebe92c8ae80f.html) (numeric-expression)SQUARE (numeric-expression)
STDDEV (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a583716084f2101595c8e7a0abc4d989.html) ( [ ALL ] expression ) [OVER ...]STDDEV ( expression ) [OVER ...]
STDDEV_POP (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a583f35984f21015b952ffc0a8c12597.html) ( [ ALL ] expression ) [OVER ...]STDDEV_POP ( expression ) [OVER ...]
STDDEV_SAMP (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a584728f84f210158226d1181b68d335.html) ( [ ALL ] expression ) [OVER ...]STDDEV_SAMP ( expression ) [OVER ...]
STR (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a584f54284f21015bb43e961aa835036.html)( numeric-expression [ , length[ , decimal ] ] )STR_UDF
STR_REPLACE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5857e0a84f210158b54cac40679f568.html)( string_expr1, string_expr2, string_expr3 )REPLACE
STRING (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a586010d84f210158657b25cdb264bf0.html)( string-expression [ , … ] )ARRAY_TO_STRING([...]. '')
STRTOUUID (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a58683c184f21015bb5cb68f114bbcb9.html) (string-expression)None

Note: Snowflake does not have any built-in function to emulate this behavior.
STUFF (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a58705b984f21015b314be7887f1392a.html) ( string-expression1, start, length, string-expression2 )INSERT
SUBSTRING (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a58787e784f21015acc5ecadf5b1a9a0.html)( string-expression, start [ , length ] )SUBSTR
SUBSTR (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a58787e784f21015acc5ecadf5b1a9a0.html)( string-expression, start [ , length ] )SUBSTR
SUBSTRING64 (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a588072e84f21015ad978a0d7bc662d8.html)( string-expression, start [ , length ] )SUBSTR
SUM (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5889fe484f21015b024abf6dcede473.html) ( expression | DISTINCT column-name ) [OVER ...]SUM ( expression | DISTINCT column-name ) [OVER ...]
SUSER_ID (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5892d8e84f21015ad62d1b43e0bae2e.html) ( [ user-name ] )CURRENT_USER( )
SUSER_NAME (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a589ad8084f21015ab2eb0b0272e8c41.html) ( [ user-id ] )CURRENT_USER( )
TAN (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a58a2ec084f2101584a8c423a3ca9750.html) (numeric-expression)TAN (numeric-expression)
TODAY (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a58aae9284f21015a550a97595a91cc9.html)( [*] )CURRENT_DATE( )
TRIM (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a58b326684f210158b01c6a84254a2f2.html)( string-expression, [ trim_character_set ] )TRIM( string-expression, [ trim_character_set ] )
TRUNCNUM (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a58baf5b84f21015961fcdf7ec6e1b8b.html)( numeric-expression, integer-expression )TRUNC( numeric-expression, integer-expression )
UCASE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a58c382984f2101586a7d1f6dcf499c3.html)(string-expression)UPPER(string-expression)
UPPER (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a58cbc0284f21015ac14f5baa190b878.html)(string-expression)UPPER(string-expression)
USER_ID (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a58d3bab84f2101590ac91b509c292c5.html)( [ user-name ] )None

Note: Snowflake does not have any built-in function to emulate this behavior.
USER_NAME (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a58dbf3184f21015b67ac2deee9f7081.html)( [ user-id ] )None

Note: Snowflake does not have any built-in function to emulate this behavior.
UUIDTOSTR (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a58e3ffd84f2101593c5c09c7d64fec4.html)( uuid-expression )None

Note: Snowflake does not have any built-in function to emulate this behavior.
VAR_POP (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a58ec03e84f21015b373c5236f4567a1.html)( [ ALL ] expression ) [OVER ...]VAR_POP( [ ALL ] expression ) [OVER ...]
VAR_SAMP (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a58f41a384f2101582a6bccb68243889.html)( [ ALL ] expression ) [OVER ...]VAR_SAMP( [ ALL ] expression ) [OVER ...]
VARIANCE (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a58fdc8684f210158b82f182e03b637a.html) ( [ ALL ] expression ) [OVER ...]VARIANCE ( [ ALL ] expression ) [OVER ...]
WEEKS (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a590601384f210158a02bf2d5a2c1783.html)( datetime-expression )
| ( datetime-expression, datetime-expression )
| ( datetime-expression, integer-expression )		WEEKS_UDF( datetime-expression )
| ( datetime-expression, datetime-expression )
| ( datetime-expression, integer-expression )
WEIGHTED_AVG (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a590e30584f210158df8d2242a037242.html) (expression) OVER (window-spec);None

Note: Snowflake does not have any built-in function to emulate this behavior.
WIDTH_BUCKET (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a591658384f21015a3a2e821679c9000.html) ( expression, min_value, max_value, num_buckets )WIDTH_BUCKET ( expression, min_value, max_value, num_buckets )
YEAR (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a591eb9d84f210159e35a75b4b036a0d.html)( date-expression )YEAR( date-expression )
YEARS (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a5926bf484f210159b3980226202882f.html)( datetime-expression )
| ( datetime-expression, datetime-expression )
| ( datetime-expression, integer-expression )		YEARS_UDF( datetime-expression )
| ( datetime-expression, datetime-expression )
| ( datetime-expression, integer-expression )
YMD (https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/a592fc9184f21015bfa68c6078363fae.html)( integer-expression1, integer-expression2, integer-expression3 )DATE_FROM_PARTS ( year, month, day )
Language: English