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?

Enricu
asked 5 years ago187 views
1 Answer
0

select DECIMAL '2.00' / 3

Enricu
answered 5 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.

Guidelines for Answering Questions