Thanks Noel ! It worked
On Thursday, May 23, 2013 2:00:17 AM UTC-5, Noel Grandin wrote:
>
> SELECT CONVERT( REPLACE(T.X, ',', ''), INT ) FROM T
>
> On 2013-05-22 21:41, Rnj wrote:
> > I'm trying to import a csv file into a h2 database table. I have a
> > number "786,960,000" to be inserted int
SELECT CONVERT( REPLACE(T.X, ',', ''), INT ) FROM T
On 2013-05-22 21:41, Rnj wrote:
I'm trying to import a csv file into a h2 database table. I have a
number "786,960,000" to be inserted into decimal column. Is there any
inbuilt function in h2 database to remove thousand separator in H2? --
Yo
I don't know of anything inbuilt. You could dump it into a varchar
column, remove all the commas (SET field = REPLACE(field, ' ')), then
alter column type to decimal?
Ryan
On 23/05/2013 3:41 AM, Rnj wrote:
I'm trying to import a csv file into a h2 database table. I have a
number "786,960,000