wood burning stoves 2.0*
The moose likes JDBC and the fly likes Instant DB , to_number function Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Databases » JDBC
Bookmark "Instant DB , to_number function" Watch "Instant DB , to_number function" New topic

Instant DB , to_number function

Natraj Gudla
Ranch Hand

Joined: Feb 09, 2003
Posts: 34
I was working with the instant DB , and was in need of a query which will sort a field of a table in ascending order.the field type is character,but contains numeric values(1,2,3etc).so said like select * from table_name order by to_number(field_name) , it raises an error that to_number is applicable to date fields.can this problem be solved , if so how.
Also i would like to know whether the same can be done in Mysql.
GeeCON Prague 2014
subject: Instant DB , to_number function