Re: [GENERAL] float to int

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 ) expressi

Re: [GENERAL] float to int

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

[GENERAL] 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. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/f