HANA SQL Functions.
HANA SQL statements allows to specify various selection function in the queries. The selection function list as below.
| Function | Explanation |
| YEAR(Date) | year |
| ADD_YEARS(Date, n) | n years later |
| DAYNAME(Date) | weekday (English) |
| CURRENT_DATE | current date |
| ABS(Number) | absolute value |
| ROUND(Number) | rounding |
| SQRT(Number) | square root |
| UPPER(String) | convert to upper case |
| SUBSTR(String, Start, Length) | cut out of a string (substring) |
| LENGTH(String) | length of a string |
provide an example for each function
LikeLike
What about more complex functions such as sin() or cos() ?
LikeLike