At the CAP-level, support for multiple databases is available (SQLite, Postgres, HANA, H2). This support includes standard operators and standard functions, portable across the database runtimes. There are various functions in this set, across different categories:
- String (
concat, length, trim, ...) - Numeric (
ceil, floor, round, ...) - Aggregate (
avg, min, max, ...) - Date / Time (
date, time, year, ...)
In this last category, what is the name of the function for calculating the number of years between two dates?
This is a question from the June Developer Challenge on CAP Knowledge. And don't forget: always submit your answer as a hash, on its own - read the Taking part section of the intro post for more info. At the end of today, this question will be updated with links to further reading on this topic.
Further info:
Bluesky
