Обсуждение: simple SQL question
I have a column with the following values (example below) 5673 4731 4462 5422 756 3060 I want the column to display the numbers as follows: 56.73 47.31 44.62 54.22 7.56 30.60 I have been playing around with string functions but cannot seem to figure out a quick solution. Does anyone have any suggestions? Please let me know. Thanks.
If the column type is a float4 or a float8 you can execute a query like this: SELECT column_name/100 FROM table_name; If the column type is other than that, you can cast it to a float and then perform the query. SELECT (column_name::float4)/100 FROM table_name; Joshua wrote: > I have a column with the following values (example below) > > 5673 > 4731 > 4462 > 5422 > 756 > 3060 > > I want the column to display the numbers as follows: > > 56.73 > 47.31 > 44.62 > 54.22 > 7.56 > 30.60 > > I have been playing around with string functions but cannot seem to > figure out a quick solution. Does anyone have any suggestions? > > Please let me know. > > Thanks. > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > > >
On Tue, 26 Jun 2007 12:30:34 am Joshua wrote: > I have a column with the following values (example below) > > 5673 > 4731 > 4462 > 5422 > 756 > 3060 > > I want the column to display the numbers as follows: > > 56.73 > 47.31 > 44.62 > 54.22 > 7.56 > 30.60 > what happens when you try select cast(MYCOL/100 as NUMERIC(4,2)) FROM MYTABLE ? Glenn > I have been playing around with string functions but cannot seem to > figure out a quick solution. Does anyone have any suggestions? > > Please let me know. > > Thanks. > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly