Progress DataDirect for JDBC Drivers Reference February 2026

Scalar functions

Save PDF

Scalar functions

Save PDF

Last Updated: June 27, 2025
1 minute read

DataDirect Connectors
JDBC
Aha! 6.0
Amazon Redshift 6.0
Apache Cassandra 6.0
Apache Hive 6.0
Apache Spark SQL 6.0
Atlassian Jira 6.0
Autonomous REST Connector 6.0
Cloudera Impala 5.1
+ 24
- Denodo 6.0
- GitHub 6.0
- Google BigQuery 6.0
- IBM Db2 5.1
- IBM Informix 6.0
- Microsoft Dynamics 365 6.0
- Microsoft Sharepoint 6.0
- Microsoft SQL Server 6.0
- MongoDB 6.1
- MongoDB 6.0
- MySQL 5.1
- Oracle Database 6.0
- Oracle Eloqua 6.0
- Oracle Sales Cloud 6.0
- Oracle Service Cloud 5.1
- PostgreSQL 6.0
- Progress OpenEdge 5.1
- Salesforce 6.0
- SAP HANA 6.0
- SAP S/4HANA 6.0
- SAP Sybase 5.1
- Snowflake 6.0
- TeamCity 6.0
- Documentation

This section describes the scalar functions that are supported by the JDBC drivers. Note that your database system may not support all these functions. The following table documents the functions supported by individual drivers. Refer to the documentation for your database system to find out which functions are supported by your database.

In addition, you can also determine the supported scalar functions by using DatabaseMetaData methods.

You can use scalar functions in SQL statements with the following syntax:

{fn scalar-function}

where:

scalar-function: is a scalar function supported by the drivers, as listed in the following table.

Example:

SELECT id, name FROM emp WHERE name LIKE {fn UCASE('Smith')}

Table 1. Supported Scalar Functions
Data Store	String Functions	Numeric Functions	Timedate Functions	System Functions
Aha!	ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT DIFFERENCE HEXTORAW INSERT LCASE LEFT LENGTH LOCATE LOCATE_2 LOWER LTRIM OCTET_LENGTH RAWTOHEX REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTR SUBSTRING UCASE UPPER	ABS ACOS ASIN ATAN ATAN2 BITAND BITOR BITXOR CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND ROUNDMAGIC SIGN SIN SQRT TAN TRUNCATE	CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATEDIFF DATE_ADD DATE_SUB DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND SECONDS_SINCE_MIDNIGHT TIMESTAMPADD TIMESTAMPDIFF TO_CHAR WEEK YEAR	CURSESSIONID DATABASE IDENTITY USER
Amazon Redshift	ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT LCASE LENGTH LEFT LOCATE LTRIM OCTET_LENGTH POSITION REPEAT REPLACE RIGHT RTRIM SUBSTRING UCASE	ABS ACOS ASIN ATAN ATAN2 CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND SIGN SIN SQRT TAN TRUNCATE	CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME EXTRACT NOW	USERNAME DBNAME IFNULL
Apache Cassandra	ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT DIFFERENCE HEXTORAW INSERT LCASE LEFT LENGTH LOCATE LOCATE_2 LOWER LTRIM OCTET_LENGTH RAWTOHEX REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTR SUBSTRING UCASE UPPER	ABS ACOS ASIN ATAN ATAN2 BITAND BITOR BITXOR CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND ROUNDMAGIC SIGN SIN SQRT TAN TRUNCATE	CURDATE CURTIME DATEDIFF DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND SECONDS_SINCE_MIDNIGHT TIMESTAMPADD TIMESTAMPDIFF TO_CHAR WEEK YEAR	CURSESSIONID DATABASE IDENTITY USER
Apache Hive	ASCII CONCAT INSERT LCASE LEFT LENGTH LOCATE LOCATE2 LTRIM REPEAT REPLACE RIGHT RTRIM SPACE SUBSTRING UCASE	ABS ACOS ASIN ATAN CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MODP PI POWER RADIANS RAND ROUND SIGN SIN SQRT TAN	CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DAYOFMONTH EXTRACT HOUR MINUTE MONTH NOW QUARTER SECOND TIMESTAMPADD ¹ TIMESTAMPDIFF WEEK YEAR	DBNAME IFNULL
Apache Impala	ASCII CONCAT INSERT LCASE LEFT LENGTH LOCATE LOCATE2 LTRIM REPEAT REPLACE RIGHT RTRIM SPACE SUBSTRING UCASE	ABS ACOS ASIN ATAN CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MODP PI POWER RADIANS RAND ROUND SIGN SIN SQRT TAN	CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DAYOFMONTH EXTRACT HOUR MINUTE MONTH NOW QUARTER SECOND TIMESTAMPADD ² TIMESTAMPDIFF WEEK YEAR	DBNAME IFNULL
Apache Spark SQL	ASCII CONCAT INSERT LCASE LEFT LENGTH LOCATE LOCATE2 LTRIM REPEAT REPLACE RIGHT RTRIM SPACE SUBSTRING UCASE	ABS ACOS ASIN ATAN CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MODP PI POWER RADIANS RAND ROUND SIGN SIN SQRT TAN	CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DAYOFMONTH EXTRACT HOUR MINUTE MONTH NOW QUARTER SECOND TIMESTAMPADD ³ TIMESTAMPDIFF WEEK YEAR	DBNAME IFNULL
Autonomous REST Connector	ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT DIFFERENCE HEXTORAW INSERT LCASE LEFT LENGTH LOCATE LOCATE_2 LOWER LTRIM OCTET_LENGTH RAWTOHEX REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTR SUBSTRING UCASE UPPER	ABS ACOS ASIN ATAN ATAN2 BITAND BITOR BITXOR CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND ROUNDMAGIC SIGN SIN SQRT TAN TRUNCATE	CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATEDIFF DATE_ADD DATE_SUB DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND SECONDS_SINCE_MIDNIGHT TIMESTAMPADD TIMESTAMPDIFF TO_CHAR WEEK YEAR	CURSESSIONID DATABASE IDENTITY USER
DB2	ASCII BLOB CHAR CHR CLOB CONCAT DAYNAMEDBCLOB DECFLOAT_FORMAT DIFFERENCE GRAPHIC HEX INITCAPINSERT INSTR LCASE or LOWER LCASE ⁴ LEFT LENGTH LOCATE LOCATE_IN_STRING LONG_VARCHAR LONG_VARGRAPHIC LPAD LTRIM LTRIM MONTHNAME POSSTR REPEAT REPLACE RIGHT RPADRTRIM RTRIM RTRIM SOUNDEX SPACE SUBSTR TO_CLOB TO_NUMBER TRUNCATE or TRUNC UCASE or UPPER VARCHAR VARGRAPHIC	ABS or ABSVAL ACOS ASIN ATAN ATANH ATAN2 BIGINT CEILING or CEIL COS COSH COT DECIMAL DEGREES DIGITS DOUBLE EXP FLOAT FLOOR INTEGER LN LOG LOG10 MOD POWER RADIANS RAND REAL ROUND SIGN SIN SINH SMALLINT SQRT TAN TANH TRUNCATE	CURDATE CURTIME DATE DAY DAYNAME DAYOFWEEK DAYOFYEAR DAYS HOUR JULIAN_DAY MICROSECOND MIDNIGHT_SECONDS MINUTE MONTH MONTHNAME NOW QUARTER SECOND TIME TIMESTAMP TIMESTAMP_ISO TIMESTAMPDIFF WEEK YEAR	COALESCE DEREF DLCOMMENT DLLINKTYPE DLURLCOMPLETE DLURLPATH DLURLPATHONLY DLURLSCHEME DLURLSERVER DLVALUE EVENT_MON_STATE GENERATE_UNIQUE NODENUMBER NULLIF PARTITION RAISE_ERROR TABLE_NAME TABLE_SCHEMA TRANSLATE TYPE_ID TYPE_NAME TYPE_SCHEMA VALUE
Denodo	ASCII CHAR CONCAT LCASE LOCATE LTRIM REPEAT REPLACE RIGHT RTRIM SUBSTRING UCASE CHAR_LENGTH INSTR LEN LOWER MAX MIN POSITION REGEXP REMOVEACCENTS REPLACEMAP SPLIT TEXTCONSTANT TRIM UPPER	ABS ACOS ASIN ATAN ATAN2 COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS ROUND SIGN SIN SQRT TAN TRUNCATE CEIL DIV LN MAX MIN MULT SUBTRACT SUM	CURRENT_DATE DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT MONTH MONTHNAME NOW QUARTER WEEK YEAR ADDDAY ADDHOUR ADDMINUTE ADDMONTH ADDWEEK ADDYEAR FIRSTDAYOFMONTH FIRSTDAYOFWEEK FORMATDATE GETDAY GETDAYOFWEEK GETDAYOFYEAR GETDAYSBETWEEN GETHOUR GETMILLISECOND GETMINUTE GETMONTH GETMONTHSBETWEEN GETQUARTER GETSECOND GETTIMEINMILLIS GETWEEK GETYEAR LASTDAYOFMONTH LASTDAYOFWEEK MAX MIN NEXTWEEKDAY PREVIOUSWEEKDAY SUBTRACT TO_DATE TRUNC	IFNULL GETSESSION NULLIF ROWNUM
GitHub	ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT DIFFERENCE HEXTORAW INSERT LCASE LEFT LENGTH LOCATE LOCATE_2 LOWER LTRIM OCTET_LENGTH RAWTOHEX REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTR SUBSTRING UCASE UPPER	ABS ACOS ASIN ATAN ATAN2 BITAND BITOR BITXOR CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND ROUNDMAGIC SIGN SIN SQRT TAN TRUNCATE	CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATEDIFF DATE_ADD DATE_SUB DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND SECONDS_SINCE_MIDNIGHT TIMESTAMPADD TIMESTAMPDIFF TO_CHAR WEEK YEAR	CURSESSIONID DATABASE IDENTITY USER
Google Analytics 4	ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT DIFFERENCE HEXTORAW INSERT LCASE LEFT LENGTH LOCATE LOCATE_2 LOWER LTRIM OCTET_LENGTH RAWTOHEX REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTR SUBSTRING UCASE UPPER	ABS ACOS ASIN ATAN ATAN2 BITAND BITOR BITXOR CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND ROUNDMAGIC SIGN SIN SQRT TAN TRUNCATE	CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATEDIFF DATE_ADD DATE_SUB DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND SECONDS_SINCE_MIDNIGHT TIMESTAMPADD TIMESTAMPDIFF TO_CHAR WEEK YEAR	CURSESSIONID DATABASE IDENTITY USER
Google BigQuery	ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT DIFFERENCE HEXTORAW INSERT LCASE LEFT LENGTH LOCATE LOCATE_2 LOWER LTRIM OCTET_LENGTH RAWTOHEX REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTR SUBSTRING UCASE UPPER	ABS ACOS ASIN ATAN ATAN2 BITAND BITOR BITXOR CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND ROUNDMAGIC SIGN SIN SQRT TAN TRUNCATE	CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATEDIFF DATE_ADD DATE_SUB DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND SECONDS_SINCE_MIDNIGHT TIMESTAMPADD TIMESTAMPDIFF TO_CHAR WEEK YEAR	CURSESSIONID DATABASE IDENTITY USER
Greenplum	ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT LCASE LENGTH LOCATE LTRIM OCTET_LENGTH POSITION REPEAT REPLACE RIGHT RTRIM SUBSTRING UCASE	ABS ACOS ASIN ATAN ATAN2 CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND SIGN SIN SQRT TAN TRUNCATE	CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME EXTRACT NOW	USERNAME DBNAME IFNULL
HubSpot	ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT DIFFERENCE HEXTORAW INSERT LCASE LEFT LENGTH LOCATE LOCATE_2 LOWER LTRIM OCTET_LENGTH RAWTOHEX REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTR SUBSTRING UCASE UPPER	ABS ACOS ASIN ATAN ATAN2 BITAND BITOR BITXOR CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND ROUNDMAGIC SIGN SIN SQRT TAN TRUNCATE	CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATEDIFF DATE_ADD DATE_SUB DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND SECONDS_SINCE_MIDNIGHT TIMESTAMPADD TIMESTAMPDIFF TO_CHAR WEEK YEAR	CURSESSIONID DATABASE IDENTITY USER
Informix	CONCAT LEFT LENGTH LTRIM REPLACE RTRIM SUBSTRING	ABS ACOS ASIN ATAN ATAN2 COS COT EXP FLOOR LOG LOG10 MOD PI POWER ROUND SIN SQRT TAN TRUNCATE	CURDATE CURTIME DAYOFMONTH DAYOFWEEK MONTH NOW TIMESTAMPADD TIMESTAMPDIFF YEAR	DATABASE USER
Jira	ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT DIFFERENCE HEXTORAW INSERT LCASE LEFT LENGTH LOCATE LOCATE_2 LOWER LTRIM OCTET_LENGTH RAWTOHEX REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTR SUBSTRING UCASE UPPER	ABS ACOS ASIN ATAN ATAN2 BITAND BITOR BITXOR CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND ROUNDMAGIC SIGN SIN SQRT TAN TRUNCATE	CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATEDIFF DATE_ADD DATE_SUB DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND SECONDS_SINCE_MIDNIGHT TIMESTAMPADD TIMESTAMPDIFF TO_CHAR WEEK YEAR	CURSESSIONID DATABASE IDENTITY USER
Microsoft Dynamics 365	ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT DIFFERENCE HEXTORAW INSERT LCASE LEFT LENGTH LOCATE LOCATE_2 LOWER LTRIM OCTET_LENGTH RAWTOHEX REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTR SUBSTRING UCASE UPPER	ABS ACOS ASIN ATAN ATAN2 BITAND BITOR BITXOR CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND ROUNDMAGIC SIGN SIN SQRT TAN TRUNCATE	CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATEDIFF DATE_ADD DATE_SUB DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND SECONDS_SINCE_MIDNIGHT TIMESTAMPADD TIMESTAMPDIFF TO_CHAR WEEK YEAR	CURSESSIONID DATABASE IDENTITY USER
Microsoft SharePoint	ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT DIFFERENCE HEXTORAW INSERT LCASE LEFT LENGTH LOCATE LOCATE_2 LOWER LTRIM OCTET_LENGTH RAWTOHEX REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTR SUBSTRING UCASE UPPER	ABS ACOS ASIN ATAN ATAN2 BITAND BITOR BITXOR CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND ROUNDMAGIC SIGN SIN SQRT TAN TRUNCATE	CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATEDIFF DATE_ADD DATE_SUB DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND SECONDS_SINCE_MIDNIGHT TIMESTAMPADD TIMESTAMPDIFF TO_CHAR WEEK YEAR	CURSESSIONID DATABASE IDENTITY USER
MySQL	ASCII CHAR CONCAT INSERT LCASE LEFT LENGTH LOCATE LOCATE_2 LTRIM REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTRING UCASE	ABSA COS ASIN ATAN ATAN2 CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND SIGN SIN SQRT TAN TRUNCATE	CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND TIMESTAMPADD TIMESTAMPDIFF WEEK YEAR	DATABASE IFNULL USER
MongoDB	ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT DIFFERENCE HEXTORAW INSERT LCASE LEFT LENGTH LOCATE LOCATE_2 LOWER LTRIM OCTET_LENGTH RAWTOHEX REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTR SUBSTRING UCASE UPPER	ABS ACOS ASIN ATAN ATAN2 BITAND BITOR BITXOR CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND ROUNDMAGIC SIGN SIN SQRT TAN TRUNCATE	CURDATE CURTIME DATEDIFF DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND SECONDS_SINCE_MIDNIGHT TIMESTAMPADD TIMESTAMPDIFF TO_CHAR WEEK YEAR	CURSESSIONID DATABASE IDENTITY USER
Oracle	ASCII BIT_LENGTH CHAR CONCAT INSERT LCASE LEFT LENGTH LOCATE LOCATE2 LTRIM OCTET_LENGTH REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTRING UCASE	ABS ACOS ASIN ATAN ATAN2 CEILING COS COT EXP FLOOR LOG LOG10 MOD PI POWER ROUND SIGN SIN SQRT TAN TRUNCATE	CURDATE DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND WEEK YEAR	IFNULL USER
Oracle Eloqua	ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT DIFFERENCE HEXTORAW INSERT LCASE LEFT LENGTH LOCATE LOCATE_2 LOWER LTRIM OCTET_LENGTH RAWTOHEX REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTR SUBSTRING UCASE UPPER	ABS ACOS ASIN ATAN ATAN2 BITAND BITOR BITXOR COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND SIGN SIN SQRT TAN TRUNCATE	CURDATE CURTIME DATEDIFF DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT HOUR MINUTE MONTH MONTHNAME NOW SECOND TO_CHAR WEEK YEAR	CURSESSIONID DATABASE IDENTITY USER IFNULL
Oracle Sales Cloud	ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT DIFFERENCE HEXTORAW INSERT LCASE LEFT LENGTH LOCATE LOCATE_2 LOWER LTRIM OCTET_LENGTH RAWTOHEX REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTR SUBSTRING UCASE UPPER	ABS ACOS ASIN ATAN ATAN2 BITAND BITOR BITXOR CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND ROUNDMAGIC SIGN SIN SQRT TAN TRUNCATE	CURDATE CURTIME DATEDIFF DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT HOUR MINUTE MONTH MONTHNAME NOW SECOND TO_CHAR WEEK YEAR	CURSESSIONID DATABASE IDENTITY USER IFNULL
Oracle Service Cloud	ASCII BITLENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT DIFFERENCE HEXTORAW INSERT LCASE LEFT LENGTH LOCATE LOWER LTRIM OCTET_LENGTH RAWTOHEX REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTR SUBSTRING UCASE UPPER	ABS ACOS ASIN ATAN ATAN2 BITAND BITOR BITXOR CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND ROUNDMAGIC SIGN SIN SQRT TAN TRUNCATE	CURDATE CURTIME DATEDIFF DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND TO_CHAR WEEK YEAR	CURSESSIONID DATABASE IDENTITY USER
PostgreSQL	ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT LCASE LENGTH LEFT ⁵ LOCATE LTRIM OCTET_LENGTH POSITION REPEAT REPLACE RIGHT RTRIM SUBSTRING UCASE	ABS ACOS ASIN ATAN ATAN2 CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND SIGN SIN SQRT TAN TRUNCATE	CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME EXTRACT NOW	USERNAME DBNAME IFNULL
Progress OpenEdge	ASCII CHAR CONCAT DIFFERENCE LCASE LEFT LENGTH LOCATE LTRIM REPEAT REPLACE RIGHT RTRIM SPACE SUBSTRING UCASE	ABS ACOS ASIN ATAN ATAN2 CEILING COS DEGREES EXP FLOOR LOG10 MOD PI POWER RADIANS ROUND SIN SQRT TAN	CURDATE CURTIME DAYNAME DAYOFMONTH DAYOFWEEK HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND TIMESTAMPADD TIMESTAMPDIFF WEEK YEAR	DATABASE IFNULL USER
Salesforce	ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT DIFFERENCE HEXTORAW INSERT LCASE LEFT LENGTH LOCATE LOCATE_2 LOWER LTRIM OCTET_LENGTH RAWTOHEX REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTR SUBSTRING UCASE UPPER	ABS ACOS ASIN ATAN ATAN2 BITAND BITOR BITXOR CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND ROUNDMAGIC SIGN SIN SQRT TAN TRUNCATE	CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATEDIFF DATE_ADD DATE_SUB DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND SECONDS_SINCE_MIDNIGHT TIMESTAMPADD TIMESTAMPDIFF TO_CHAR WEEK YEAR	CURSESSIONID DATABASE IDENTITY USER
SAP HANA	ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT DIFFERENCE HEXTORAW INSERT LCASE LEFT LENGTH LOCATE LOCATE_2 LOWER LTRIM OCTET_LENGTH RAWTOHEX REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTR SUBSTRING UCASE UPPER	ABS ACOS ASIN ATAN ATAN2 BITAND BITOR BITXOR CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND ROUNDMAGIC SIGN SIN SQRT TAN TRUNCATE	CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATEDIFF DATE_ADD DATE_SUB DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND SECONDS_SINCE_MIDNIGHT TIMESTAMPADD TIMESTAMPDIFF TO_CHAR WEEK YEAR	CURSESSIONID DATABASE IDENTITY USER
SAP S/4HANA	ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT DIFFERENCE HEXTORAW INSERT LCASE LEFT LENGTH LOCATE LOCATE_2 LOWER LTRIM OCTET_LENGTH RAWTOHEX REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTR SUBSTRING UCASE UPPER	ABS ACOS ASIN ATAN ATAN2 BITAND BITOR BITXOR CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND ROUNDMAGIC SIGN SIN SQRT TAN TRUNCATE	CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATEDIFF DATE_ADD DATE_SUB DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND SECONDS_SINCE_MIDNIGHT TIMESTAMPADD TIMESTAMPDIFF TO_CHAR WEEK YEAR	CURSESSIONID DATABASE IDENTITY USER
Snowflake	ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT DIFFERENCE HEXTORAW INSERT LCASE LEFT LENGTH LOCATE LOCATE_2 LOWER LTRIM OCTET_LENGTH RAWTOHEX REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTR SUBSTRING UCASE UPPER	ABS ACOS ASIN ATAN ATAN2 BITAND BITOR BITXOR CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND ROUNDMAGIC SIGN SIN SQRT TAN TRUNCATE	CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATEDIFF DATE_ADD DATE_SUB DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND SECONDS_SINCE_MIDNIGHT TIMESTAMPADD TIMESTAMPDIFF TO_CHAR WEEK YEAR	CURSESSIONID DATABASE IDENTITY USER
Sybase	ASCII CHAR CONCAT DIFFERENCE INSERT LCASE LEFT LENGTH LOCATE LTRIM REPEAT RIGHT RTRIM SOUNDEX SPACE SUBSTRING UCASE	ABS ACOS ASIN ATAN ATAN2 CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND SIGN SIN SQRT TAN	DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND TIMESTAMPADD TIMESTAMPDIFF WEEK YEAR	DATABASE IFNULL USER
SQL Server	ASCII CHAR CONCAT DIFFERENCE INSERT LCASE LEFT LENGTH LOCATE LTRIM REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTRING UCASE	ABS ACOS ASIN ATAN ATAN2 CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND SIGN SIN SQRT TAN TRUNCATE	DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND TIMESTAMPADD TIMESTAMPDIFF WEEK YEAR	DATABASE IFNULL USER
TeamCity	ASCII BIT_LENGTH CHAR CHAR_LENGTH CHARACTER_LENGTH CONCAT DIFFERENCE HEXTORAW INSERT LCASE LEFT LENGTH LOCATE LOCATE_2 LOWER LTRIM OCTET_LENGTH RAWTOHEX REPEAT REPLACE RIGHT RTRIM SOUNDEX SPACE SUBSTR SUBSTRING UCASE UPPER	ABS ACOS ASIN ATAN ATAN2 BITAND BITOR BITXOR CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS RAND ROUND ROUNDMAGIC SIGN SIN SQRT TAN TRUNCATE	CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATEDIFF DATE_ADD DATE_SUB DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT HOUR MINUTE MONTH MONTHNAME NOW QUARTER SECOND SECONDS_SINCE_MIDNIGHT TIMESTAMPADD TIMESTAMPDIFF TO_CHAR WEEK YEAR	CURSESSIONID DATABASE IDENTITY USER

¹ Apache Hive is limited to adding only days to a timestamp.

² Apache Impala is limited to adding only days to a timestamp.

³ Apache Spark SQL is limited to adding only days to a timestamp.

⁴ SYSFUN schema.

⁵ Supported for PostgreSQL 9.1 and higher