MySQL: Convert Unix Timestamp to Date

Yes, there is a function.

It is called FROM_UNIXTIME and you can use it with or without parameter.

SELECT FROM_UNIXTIME(1517440125);

-> '2018-02-01 00:08:45'

Without parameter the result will be this format. If you want to determine your own format, you can pass the formatting as parameter:

SELECT FROM_UNIXTIME(1517440125, '%d.%m.%Y %H%i%s');

-> '01.02.2018 00:08:45'

As you can see, %d is standing for the day, %m for the month, %Y for the year and so on. You can use other characters between those placeholders like points or spaces as you can see in the example.
2016-03-10 at 14:23