Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Instant DB , to_number function

 
Natraj Gudla
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic