Valentina DB has hundreds of database calculation functions built right in, ready to use with SQL, checks and table methods.
With Calculation functions (also known as calculated fields or table methods), you can create virtual fields that calculate values dynamically, based on data stored in your database. They can be used with any type of field (except for BLOB fields). These include:
- operators
- operator ->
- bit functions
- numeric fucntions
- trigonometric functions
- date/time functions
- string functions
- logical functions
- comparision functions
- aggregate functions
- run time functions
- link-based functions
- collection functions
For a comprehensive list of functions, visit the Paradigma Software documentation wiki.