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

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 |