Hi:

 

if...   

create table coords (id int, x float, y float);

then...  

insert into coords (id,x,y) values (1,1.000,2.001)

and then...

            select * from coords

i get...

            1,1,2.001

i want...

            1.1.000,2.001

while retaining the numeric nature of the x,y data (for math ops in
other operations).

 

How can I reformat the float output (sort of like using "%5.3f" in
good-ole C)

 

Thanks !

Reply via email to