Applications connecting through JDBC or ODBC to Progress OpenEdge® 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 | CURRENT DATE | DATABASE |

BIT_LENGTH | ACOS | CURRENT_TIME | IFNULL |

CHAR | ASIN | CURRENT_TIMESTAMP | ROWID |

CHAR_LENGTH | ATAN | CURDATE | USER |

CHARACTER_LENGTH | ATAN2 | CURTIME | |

CONCAT | CEILING | DAYNAME | |

DIFFERENCE | COS | DAYOFMONTH | |

INSERT | COT | DAYOFWEEK | |

LCASE | DEGREES | DAYOFYEAR | |

LEFT | EXP | HOUR | |

LENGTH | FLOOR | MINUTE | |

LOCATE | LOG | MONTH | |

LTRIM | LOG10 | MONTHNAME | |

OCTET_LENGTH | MOD | NOW | |

POSITION | PI | QUARTER | |

REPEAT | POWER | SECOND | |

REPLACE | RADIANS | TIMESTAMPADD | |

RIGHT | RAND | TIMESTAMPDIFF | |

RTRIM | ROUND | WEEK | |

SPACE | SIGN | YEAR | |

SUBSTRING | SIN | ||

UCASE | SQRT | ||

TAN | |||

TRUNCATE |