I need to use sin to calculate the distance between two points on the earth.
In orcale it has the functions:SIN,ACOS,SQRT, but in TT the same sentence is wrong.
Now I have a question:how can I realize SIN.
TimesTen doesnt have a lot of math functions, therefore you can use the following options:
- calculate math functions (sin, cos and etc.) on application level. Different programming languages contain a very rich functional for math ( look at java.lang.Math for Java for instance).
- use "Passthrough" TimesTen feature which provides you an opportunity to execute the query in Oracle instead of TimesTen. It works for In-Memory DB Cache only :(