Skip site navigation (1) Skip section navigation (2)

conversion a numero

From: Juan <smalltalker(dot)marcelo(at)gmail(dot)com>
To: Ayuda <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: conversion a numero
Date: 2010-09-29 19:04:03
Message-ID: AANLkTi=bW6c3rw7LbV+g9CD=1Zmr8rimn9UA5oHZXmzk@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
Gente

tengo un problema ,necesito convertir a numero o float ( con decimales )
un character varying,
por ejemplo

'0.00121' --> 0.00121
'100.23'   -> 100.23
'123'   ->     123

que funcion aplican para lograr dicha conversion?
saludos
mdc

Responses

pgsql-es-ayuda by date

Next:From: Jaime CasanovaDate: 2010-09-29 19:06:43
Subject: Re: conversion a numero
Previous:From: Jaime CasanovaDate: 2010-09-29 18:31:50
Subject: Re: Duda con orden de triggers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group