title: mySQL - How to convert a string to an int and string to date using sql query
body: <p>so I have this table that stores the quantity and created_on(date) field as a string, I want to convert the quantity field to int and the created_on field to date, because I want to manipulate the data in PowerBI, therefore I want to create view that converts the fields to manage the data correctly. This is my current query that gets the four fields I need for my view</p>
  <pre><code>SELECT total_qty, delivery_agent_name, created_on, shipment_stage
  FROM  express_shipment
  </code></pre>
  <p>And this is the output, which would be the same once the conversion is done, I just need the conversion for PowerBI purposes.
  <a href="https://i.stack.imgur.com/fb0Ez.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fb0Ez.png" alt="enter image description here" /></a>
  Thank you again!</p>