I have created a table where I listed some spare parts of my company.  

The Table looks like this:  

```
ID | Name | install_date | last_changed | order_nr. | WearStatus
----------
1  | "ABC" | **2017-11-08 10:34:40** | NULL | 123456 | **50**<br>
2  | "DEF" | **2017-11-08 10:34:40** | NULL | 654321 | **10**<br>

```

.  

.

I want to calculate the Future Date, where the spare Parts should be changed. For example:  

I installed a Part on the 01. December and exactly 10 Days later on the 11. December this part has a Wear of 50%, then I know: It has 10 more Days left.  

My calculation is according to the rule of three formula: **Time = (100 \* delta t) / Wear**

I use the following SQL command: 

```
SELECT ( (100*(CURRENT_TIMESTAMP - First_Usage) / Wear) + First_Usage) As 'Change_Date' FROM spare_parts

```

And get the following Results:

[![enter image description here](https://i.stack.imgur.com/vVmvy.png)](https://i.stack.imgur.com/vVmvy.png)

If you see there are some crazy DATE\_TIMES like **2017-19-41-43-19-31**.   

So my Question is now: How to format this "Numbers" to a useful DATE\_TIME Format like **YYYY-MM-DD hh:mm:ss** ?

kind regards Toby