The table identifies the scalar functions supported by DataDirect Cloud for Hubspot.

Applications can construct SQL statements using the following syntax, where scalar-function is one of the functions listed in the following tables:

{fn scalar-function}

For example:

SELECT {fn

UCASE(NAME)} FROM EMP

UCASE(NAME)} FROM EMP

Applications connecting through JDBC or ODBC to HubSpot can use the following scalar functions in expressions. For syntax details, consult your JDBC or ODBC documentation.

String Functions | Numeric Functions | Timedate Functions | System Functions | Aggregate Functions | Other Functions |

ASCII | ABS | CURDATE | DATABASE | AVG | CAST |

BIT_LENGTH | ACOS | CURTIME | USER | COUNT | CONVERT |

CHAR | ASIN | CURTIMESTAMP | DENSE_RANK | DECODE | |

CHAR_LENGTH | ATAN | DATEADD | MAX | IFNULL | |

CHARACTER_LENGTH | ATAN2 | DATEDIFF | MIN | ISNULL | |

CONCAT | CEILING | DAYNAME | RANK | NVL | |

INSERT | COS | DAYOFMONTH | ROW_NUMBER | ||

LCASE | COT | DAYOFWEEK | STDDEV | ||

LOWER | DEGREES | DAYOFYEAR | STDDEV_SAMP | ||

LEFT | EXP | HOUR | STDEV | ||

LENGTH | FLOOR | MINUTE | STDDEVP | ||

LOCATE | LOG | MONTH | STDDEV_POP | ||

LTRIM | LOG10 | MONTHNAME | STDEVP | ||

OCTET_LENGTH | MOD | NOW | SUM | ||

POSITION | PI | QUARTER | VAR | ||

REPEAT | POWER | SECOND | VAR_SAMP | ||

REPLACE | RADIANS | TIMESTAMPADD | VARP | ||

RIGHT | RAND | TIMESTAMPDIFF | VAR_POP | ||

RTRIM | ROUND | WEEK | |||

SPACE | SIGN | YEAR | |||

SUBSTR | SIN | ||||

SUBSTRING | SQRT | ||||

UCASE | TAN | ||||

UPPER | TRUNCATE | ||||

UCASE |