Skip to content

Return integer instead of float

0

Doing the following query 'select 2/3;' returns 0 but it should return 0.66666 . How I can get the decimals values?

Any idea?

asked 7 years ago298 views
1 Answer
0

select DECIMAL '2.00' / 3

answered 7 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.