Re: float to int

From: Edoardo Panfili <edoardo(at)aspix(dot)it>
To: "Charles(dot)Hou" <ivan(dot)hou(at)msa(dot)hinet(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: float to int
Date: 2007-11-12 15:10:47
Message-ID: 47386CF7.2060608@aspix.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)talk(dot)google(dot)com
tel: 075 9142766

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-11-12 15:13:38 Re: PQexec(), what should I do for the "NULL in command" problem?
Previous Message Ken Winter 2007-11-12 15:04:12 How to uninstall the geometry package?