title: How to convert decimal to time in Oracle SQL?
body: <p>In a certain table I'm querying, time is stored like this:
  <br>
  09:30 is stored as 9,3
  <br>
  14:25 is stored as 14,25</p>
  
  <p>How can I, using SQL, convert 9,3 to 09:30 (hh:mm format)? 
  So far, the only thing I could find in other questions are people who need to convert 9,5 to 09:30 (in my case, 9,5 means 09:50).</p>
  
  <p>Right now, I'm using PHP to convert this. But my DB server is better than my application server. Since I need to get a lot of data, it would be better to solve this using SQL.</p>
  
  <p>Sorry if this is a stupid question, but I'm new to SQL. Feel free to ask for more questions if you need to.</p>