Hibernate Community • View topic - HOL function to convert string to integer

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

HOL function to convert string to integer

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

scientia

Post subject: HOL function to convert string to integer

Posted: Tue Dec 22, 2009 4:24 am

Newbie

Joined: Fri Jul 03, 2009 1:32 am
Posts: 7

Hi,

I have a varchar field in DB , which is use to store a series number which has the fromat "XYZ01" , and my requirement is to fetch the largest number of this field. I use "select max(substring(vt.voucherNumber,4)) ....." to do this. but its not retrieve max value . And this query is not getting executed after i modified the query as "select max(to_number(substring(vt.voucherNumber,4)))....."

please help !

Ajil

Top

Page 1 of 1

[ 1 post ]

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