TimesTen does not currently support trigonometric functions. The only workaround is to move this processing logic into application code. Of course, that is not always a good solution...
Thanks for you answer anyway.
sin/cos/asin really make me suffer for three days.
1. First I wanna use external function call c or java math method , but luckily, timesten doesn't support it. (oracle does)
2. Then I write my own sin/cos/asin algorithm in user defined function (took a long time to make it happen) , but still luckily, timesten doesn't support call user defined function in sql
I sincerely hope timesten support trigonometric functions and calling user defined function in sql in the next edition (it's still 126.96.36.199.5, should be 12.* like the oracle 12c).
It's a long way since v7.0, I think it's the time to make user happier. Otherwise people should looking solidb for substitute.