The table identifies the scalar functions that DataDirect Cloud supports for MySQL.

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 | DATABASE |

CHAR | ACOS | CURRENT_DATE | IFNULL |

CONCAT | ASIN | CURRENT_TIME | USER |

INSERT | ATAN | CURRENT_TIMESTAMP | |

LCASE | ATAN2 | CURTIME | |

LEFT | CEILING | DAYNAME | |

LENGTH | COS | DAYOFMONTH | |

LOCATE | COT | DAYOFWEEK | |

LOCATE_2 | DEGREES | DAYOFYEAR | |

LTRIM | EXP | EXTRACT | |

REPEAT | FLOOR | HOUR | |

REPLACE | LOG | MINUTE | |

RIGHT | LOG10 | MONTH | |

RTRIM | MOD | MONTHNAME | |

SOUNDEX | PI | NOW | |

SPACE | POWER | QUARTER | |

SUBSTRING | RADIANS | SECOND | |

UCASE | RAND | TIMESTAMPADD | |

ROUND | TIMESTAMPDIFF | ||

SIGN | WEEK | ||

SIN | YEAR | ||

SQRT | |||

TAN | |||

TRUNCATE |