Link Search Menu Expand Document Documentation Menu

Supported Built-in Functions

Babelfish provides limited support for system-implemented built-in functions. The following lists detail the functionality implemented for each version of Babelfish (and subsequent releases).

The following built-in functions are supported for versions 2.1.0 and higher:

  • IS_MEMBER()
  • IS_ROLEMEMBER()
  • HAS_PERMS_BY_NAME()

The following built-in functions are supported for versions 1.2.0 and higher:

  • COLUMNS_UPDATED()
  • UPDATE()
  • FULLTEXTSERVICEPROPERTY()
  • ISJSON()
  • JSON_QUERY()
  • JSON_VALUE()
  • HAS_DBACCESS()
  • SUSER_SID()
  • SUSER_SNAME()
  • IS_SRVROLEMEMBER()

The following built-in functions are supported for versions 1.1.0 and higher:

  • CONCAT_WS
  • DATEFROMPARTS
  • DATETIMEFROMPARTS
  • ORIGINAL_LOGIN
  • SESSION_USER
  • SQUARE
  • CHOOSE
  • TRIGGER_NESTLEVEL
  • CURSOR_STATUS

The following built-in functions are supported for versions 1.0.0 and higher:

  • ABS
  • ACOS
  • ASCII
  • ASIN
  • ATAN
  • APPLOCK_MODE
  • APPLOCK_TEST
  • CAST
  • CEILING
  • CHAR
  • CHARINDEX
  • CHECKSUM
  • COALESCE
  • CONCAT
  • CONVERT
  • COS
  • COT
  • CURRENT_TIMESTAMP
  • CURRENT_USER
  • USER
  • DATALENGTH
  • DATEADD
  • DATEDIFF
  • DATENAME
  • DATEPART
  • DAY
  • DB_ID
  • DB_NAME
  • SUSER_ID
  • SUSER_NAME
  • USER_ID
  • USER_NAME
  • DEFAULT_DOMAIN
  • DEGREES
  • EXP
  • ERROR_LINE
  • ERROR_MESSAGE
  • ERROR_NUMBER
  • ERROR_PROCEDURE
  • ERROR_SEVERITY
  • ERROR_STATE
  • FLOOR
  • GETDATE
  • GETUTCDATE
  • IIF
  • ISDATE
  • ISNULL
  • ISNUMERIC
  • LEFT
  • LEN
  • LOG
  • LOG10
  • LOWER
  • LTRIM
  • MONTH
  • NCHAR
  • NEWID
  • NULLIF
  • OBJECT_ID
  • OBJECT_NAME
  • PATINDEX
  • PI
  • POWER
  • RADIANS
  • RAND
  • REPLACE
  • REPLICATE
  • REVERSE
  • RIGHT
  • ROUND
  • RTRIM
  • SCOPE_IDENTITY
  • IDENT_CURRENT
  • IDENT_INCR
  • IDENT_SEED
  • SCHEMA_ID
  • SCHEMA_NAME
  • SERVERPROPERTY
  • SIGN
  • SIN
  • SPACE
  • SQRT
  • STRING_AGG
  • STRING_SPLIT
  • STUFF
  • SUBSTRING
  • SYSDATETIME
  • SYSDATETIMEOFFSET
  • SYSUTCDATETIME
  • TAN
  • TRIM
  • TRY_CAST
  • TRY_PARSE
  • UPPER
  • YEAR
  • QUOTENAME
  • XACT_STATE
  • STRING_ESCAPE
  • DATABASEPROPERTYEX
  • CONNECTIONPROPERTY
  • SQL_VARIANT_PROPERTY
  • SESSIONPROPERTY
  • COLLATIONPROPERTY
  • UNICODE

  • TRIGGER_NESTLEVEL() is supported but only without arguments.

Unsupported Built-in Functions

The following Built-in functions are not supported:

  • ABS
  • ACOS
  • APPLOCK_MODE
  • APPLOCK_TEST
  • APP_NAME
  • ASCII
  • ASIN
  • ASSEMBLYPROPERTY
  • ASYMKEYPROPERTY
  • ASYMKEY_ID
  • ATAN
  • ATN2
  • BINARY_CHECKSUM
  • CAST
  • CEILING
  • CERTENCODED
  • CERTPRIVATEKEY
  • CERTPROPERTY
  • CERT_ID
  • CHAR
  • CHARINDEX
  • CHECKSUM
  • CHOOSE
  • COALESCE
  • COLLATIONPROPERTY
  • COLUMNPROPERTY
  • COLUMNS_UPDATED
  • COL_LENGTH
  • COL_NAME
  • COMPRESS
  • CONCAT
  • CONCAT_WS
  • CONNECTIONPROPERTY
  • CONTAINS
  • CONTAINSTABLE
  • CONTEXT_INFO
  • CONVERT
  • COS
  • COT
  • CURRENT_REQUEST_ID
  • CURRENT_TIMESTAMP
  • CURRENT_TIMEZONE
  • CURRENT_TIMEZONE_ID
  • CURRENT_TRANSACTION_ID
  • CURRENT_USER
  • CURSOR_STATUS
  • DATABASEPROPERTY
  • DATABASEPROPERTYEX
  • DATABASE_PRINCIPAL_ID
  • DATALENGTH
  • DATEADD
  • DATEDIFF
  • DATEDIFF_BIG
  • DATEFROMPARTS
  • DATENAME
  • DATEPART
  • DATETIME2FROMPARTS
  • DATETIMEFROMPARTS
  • DATETIMEOFFSETFROMPARTS
  • DAY
  • DB_ID
  • DB_NAME
  • DECOMPRESS
  • DEGREES
  • DIFFERENCE
  • EOMONTH
  • ERROR_LINE
  • ERROR_MESSAGE
  • ERROR_NUMBER
  • ERROR_PROCEDURE
  • ERROR_SEVERITY
  • ERROR_STATE
  • EVENTDATA
  • EXP
  • FILEGROUPPROPERTY
  • FILEGROUP_ID
  • FILEGROUP_NAME
  • FILEPROPERTY
  • FILEPROPERTYEX
  • FILE_ID
  • FILE_IDEX
  • FILE_NAME
  • FLOOR
  • FN_GET_SQL
  • FORMAT
  • FORMATMESSAGE
  • GETANSINULL
  • GETDATE
  • GETUTCDATE
  • GET_FILESTREAM_TRANSACTION_CONTEXT
  • HASHBYTES
  • HAS_DBACCESS
  • HAS_PERMS_BY_NAME
  • HOST_ID
  • HOST_NAME
  • IDENTITY
  • IDENT_CURRENT
  • IDENT_INCR
  • IDENT_SEED
  • IIF
  • INDEXKEY_PROPERTY
  • INDEXPROPERTY
  • INDEX_COL
  • ISDATE
  • ISJSON
  • ISNULL
  • ISNUMERIC
  • IS_MEMBER
  • IS_OBJECTSIGNED
  • IS_ROLEMEMBER
  • IS_SRVROLEMEMBER
  • JSON
  • JSON_MODIFY
  • JSON_QUERY
  • JSON_VALUE
  • KEY_GUID
  • KEY_ID
  • KEY_NAME
  • LEFT
  • LEN
  • LOG
  • LOG10
  • LOGINPROPERTY
  • LOWER
  • LTRIM
  • MIN_ACTIVE_ROWVERSION
  • MONTH
  • NCHAR
  • NEWID
  • NEWSEQUENTIALID
  • NULLIF
  • OBJECTPROPERTY
  • OBJECTPROPERTYEX
  • OBJECT_DEFINITION
  • OBJECT_ID
  • OBJECT_NAME
  • OBJECT_SCHEMA_NAME
  • OPENDATASOURCE
  • OPENJSON
  • OPENQUERY
  • OPENROWSET
  • OPENXML
  • ORIGINAL_DB_NAME
  • ORIGINAL_LOGIN
  • PARSE
  • PARSENAME
  • PARTITION
  • PATINDEX
  • PERMISSIONS
  • PI
  • POWER
  • PUBLISHINGSERVERNAME
  • QUOTENAME
  • RADIANS
  • RAND
  • REPLACE
  • REPLICATE
  • REVERSE
  • RIGHT
  • ROUND
  • ROWCOUNT_BIG
  • RTRIM
  • SCHEMA_ID
  • SCHEMA_NAME
  • SCOPE_IDENTITY
  • SERVERPROPERTY
  • SESSIONPROPERTY
  • SESSION_CONTEXT
  • SESSION_USER
  • SIGN
  • SIGNBYASYMKEY
  • SIGNBYCERT
  • SIN
  • SMALLDATETIMEFROMPARTS
  • SOUNDEX
  • SPACE
  • SQL_VARIANT_PROPERTY
  • SQRT
  • SQUARE
  • STATS_DATE
  • STR
  • STRING_AGG
  • STRING_ESCAPE
  • STRING_SPLIT
  • STUFF
  • SUBSTRING
  • SUSER_ID
  • SUSER_NAME
  • SUSER_SID
  • SUSER_SNAME
  • SID_BINARY
  • SWITCHOFFSET
  • SYMKEYPROPERTY
  • SYSDATETIME
  • SYSDATETIMEOFFSET
  • SYSTEM_USER
  • SYSUTCDATETIME
  • TAN
  • TERTIARY_WEIGHTS
  • TEXTPTR
  • TEXTVALID
  • TIMEFROMPARTS
  • TODATETIMEOFFSET
  • TRANSLATE
  • TRIGGER_NESTLEVEL
  • TRIM
  • TRY_CAST
  • TRY_CONVERT
  • TRY_PARSE
  • TYPEPROPERTY
  • TYPE_ID
  • TYPE_NAME
  • UNICODE
  • UPDATE
  • UPPER
  • USER
  • USER_ID
  • USER_NAME
  • VERIFYSIGNEDBYASMKEY
  • VERIFYSIGNEDBYCERT
  • VERIGYSIGNEDBYCERT
  • XACT_STATE
  • YEAR
  • CHANGETABLE
  • CHANGE_TRACKING_MIN_VALID_VERSION
  • CHANGE_TRACKING_CURRENT_VERSION
  • CHANGE_TRACKING_IS_COLUMN_IN_MASK
  • CHANGE_TRACKING_CONTEXT
  • DEFAULT_DOMAIN
  • FILETABLEROOTPATH
  • GETFILENAMESPACEPATH
  • GETPATHLOCATOR
  • PATHNAME
  • CONTAINSTABLE
  • FREETEXT
  • FREETEXTTABLE
  • SEMANTICKEYPHRASETABLE
  • SEMANTICSIMILARITYDETAILSTABLE
  • SEMANTICSIMILARITYTABLE
  • FULLTEXTCATALOGPROPERTY
  • FULLTEXTSERVICEPROPERTY
  • ENCRYPTBYASYMKEY
  • ENCRYPTBYCERT
  • ENCRYPTBYKEY
  • ENCRYPTBYPASSPHRASE
  • PWDCOMPARE
  • PWDENCRYPT
  • DECRYPTBYASYMKEY
  • DECRYPTBYCERT
  • DECRYPTBYKEY
  • DECRYPTBYKEYAUTOASYMKEY
  • DECRYPTBYKEYAUTOCERT
  • DECRYPTBYPASSPHRASE
  • DECRYPTBYKEYAUTOCERT
  • PREDICT

Babelfish for PostgreSQL Links