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

Applications connecting through JDBC or ODBC 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 |

ASCII | ABS | CURDATE | CURSESSIONID |

BIT_LENGTH | ACOS | CURTIME | DATABASE |

CHAR | ASIN | DATEDIFF | IDENTITY |

CHAR_LENGTH | ATAN | DAY | USER |

CHARACTER_LENGTH | ATAN2 | DAYNAME | IFNULL |

CONCAT | CEILING | DAYOFMONTH | |

DIFFERENCE | BITAND | DAYOFWEEK | |

HEXTORAW | BITOR | DAYOFYEAR | |

INSERT | BITXOR | EXTRACT | |

LCASE | COS | HOUR | |

LEFT | COT | MINUTE | |

LENGTH | DEGREES | MONTH | |

LOCATE | EXP | MONTHNAME | |

LOCATE_2 | FLOOR | NOW | |

LOWER | LOG | SECOND | |

LTRIM | LOG10 | TO_CHAR | |

OCTET_LENGTH | MOD | WEEK | |

RAWTOHEX | PI | YEAR | |

REPEAT | POWER | ||

REPLACE | RADIANS | ||

RIGHT | RAND | ||

RTRIM | ROUND | ||

SOUNDEX | SIGN | ||

SPACE | SIN | ||

SUBSTR | SQRT | ||

SUBSTRING | TAN | ||

UCASE | TRUNCATE | ||

UPPER | ROUNDMAGIC |