vascoc Posted June 19, 2012 at 09:48 AM Report Share #463946 Posted June 19, 2012 at 09:48 AM Boas, eu tenho andado a trabalhar com preços de produtos e isso, do tipo, 19,50€, mas depois a fazer cálculos ando com problemas, qual é o melhor formato para usar como moeda ? O tipo money insere demasiado zeros tipo isto '230,50' passa a '230,50000000', o que dizem ? Obrigado. Link to comment Share on other sites More sharing options...
vascoc Posted June 19, 2012 at 02:36 PM Author Report Share #464044 Posted June 19, 2012 at 02:36 PM Alguma ideia ? Link to comment Share on other sites More sharing options...
KiNgPiTo Posted June 19, 2012 at 02:41 PM Report Share #464047 Posted June 19, 2012 at 02:41 PM Um simples float(10,2) ou decimal(10,2) resolve-te o problema. Link to comment Share on other sites More sharing options...
vascoc Posted June 19, 2012 at 02:57 PM Author Report Share #464063 Posted June 19, 2012 at 02:57 PM Um simples float(10,2) ou decimal(10,2) resolve-te o problema. "Decimal" querias dizer Numeric ? Link to comment Share on other sites More sharing options...
KiNgPiTo Posted June 19, 2012 at 03:08 PM Report Share #464071 Posted June 19, 2012 at 03:08 PM É praticamente igual apenas muda a precisão que é fixa para o NUMERIC. Mas penso que para o caso podes escolher uma delas à vontade... Link to comment Share on other sites More sharing options...
vascoc Posted June 19, 2012 at 03:14 PM Author Report Share #464075 Posted June 19, 2012 at 03:14 PM Está bom, obrigado 🙂 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now