The table identifies the scalar functions supported by Hybrid Data Pipeline 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 |