SAP HANA SQLScript · Numbers, Units & Type Conversions

Do these two rows return the same value? ``` TO_DOUBLE(1.2)-TO_DOUBLE(0.1) TO_SMALLDECIMAL(1.2) -TO_SMALLDECIMAL(0.1) ```

Answer locked. Get the free KnowCard app to reveal it — plus spaced-repetition review so it actually sticks.

This is one card from the KnowCard library — thousands more across SAP, Linux, Python and more. In the app you get the answer, AI explanations, and cards that come back right before you would forget them. Free to start on iOS, Android or the web.

More in Numbers, Units & Type Conversions

CONVERT_UNIT returns nothing useful on a fresh HANA box. Which ERP tables must exist, and what key must you pass?

What does currency conversion require that quantity conversion doesn't, and what sets a currency's number of decimal places?

You INSERT the two-character text 'AB' into a VARBINARY column, then SELECT it back. What do you get?

What does this return with BITSET? ``` SELECT BITSET(x'0000', 9, 4) FROM dummy; ```

What is the difference between implicit and explicit conversion in SQLScript, and how does CAST relate to the TO_* functions?

A search uses HAMMING_DISTANCE(firstname,'Mandy') BETWEEN 0 AND 1. Why does it miss 'Mand' and 'Mandyy'?

Start learning today

Free to start — download the app or use it in your browser.