return decimal values from ZSQL (Oracle) [Q]
25 Dec
1999
25 Dec
'99
7:52 p.m.
Hello... I have an Oracle table where a field is a NUMBER .... I do a SELECT field FROM oratable and I get "2.29" ... (without quotes ;-) But when doing the same SELECT from a ZSQL I get "2" ... no decimals. I don't know if it's an Oracle specific problem... Anyone has a clue? I tryied using the TO_NUMBER(field, '9999.99') function but it returns "2"... TIA /B Bruno Mattarollo <brunomadv@ciudad.com.ar>
9598
Age (days ago)
9598
Last active (days ago)
0 comments
1 participants
participants (1)
-
Bruno Mattarollo