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

Applications connecting through JDBC or ODBC can use the following scalar functions in expressions. For syntax details, consult the JDBC Documentation from Oracle or the ODBC Programmer's Reference from Microsoft Corporation.

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 |