Thread: float to int
how can i get the int value using the sql language? like this, "select cost from my_money_table " , the data type of cost is float.
Charles.Hou ha scritto: > how can i get the int value using the sql language? like this, > > "select cost from my_money_table " , the data type of cost is float. > take a look at http://www.postgresql.org/docs/8.2/static/sql-expressions.html CAST ( expression AS type ) expression::type Edoardo -- Jabber: edoardopa@talk.google.com tel: 075 9142766
Edoardo Panfili wrote: > Charles.Hou ha scritto: >> how can i get the int value using the sql language? like this, >> >> "select cost from my_money_table " , the data type of cost is float. >> > take a look at > http://www.postgresql.org/docs/8.2/static/sql-expressions.html > CAST ( expression AS type ) > expression::type Incidentally, float is about the worst data type to represent monetary amounts that one can choose. -- Lew