Hibernate Community • View topic - Convert from String to Integer in SQL

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Convert from String to Integer in SQL

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

kalstevens

Post subject: Convert from String to Integer in SQL

Posted: Fri Jun 05, 2009 2:28 pm

Newbie

Joined: Sat Dec 30, 2006 3:07 pm
Posts: 16

I would like to order by a String, which in some cases I know contains an integer.

Like this

select * from vo_meta_data where md_key="relevance" order by CONVERT(md_value, SIGNED) desc;

here md_value is stored as a string, but in this perticular case I know it is an integer.

The problem is that if I have values "100", and "8" they are ordered incorrectly.

I could 0 pad, but I prefer not to do that if there is an HQL alternative.

Top

fge

Post subject: Re: Convert from String to Integer in SQL

Posted: Sun Jun 07, 2009 5:08 am

Beginner

Joined: Mon Jun 01, 2009 5:39 am
Posts: 34

You can use the cast function:

Code:

select * from vo_meta_data where md_key = 'relevance' order by cast(md_value, int);

Top

Page 1 of 1

[ 2 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