Hibernate Community • View topic - String to int conversion with aggregate

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

String to int conversion with aggregate

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

cruelkoder

Post subject: String to int conversion with aggregate

Posted: Tue Jan 15, 2008 3:45 pm

Newbie

Joined: Fri Mar 17, 2006 3:40 pm
Posts: 1

All,
I have a column of type String and the values in it are purely numbers. I would like to get a SUM on that String column.

How do i do this?

Thanks

Top

greenbee

Post subject:

Posted: Tue Oct 28, 2008 4:12 pm

Beginner

Joined: Mon Mar 17, 2008 2:50 pm
Posts: 24

If you haven't yet found an answer you can do it in plain (native) sql query:

Code:

select sum(convert(your_column, DECIMAL)) from whatever_table where <your where clause>

I am using MySQL functions but any RDBMS have their own sybtax in this regard. Just RTFM.

Top

Rober2D2

Post subject:

Posted: Tue Oct 28, 2008 5:33 pm

Beginner

Joined: Tue Oct 30, 2007 7:57 am
Posts: 47

Yes, just use the same functions as if you where querying your database. Unfortunately, there is not an standard for this.

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum