How do I convert UNIX timestamps to the date format d.m.Y inside a query
I am trying to write a query but I have run into a snag. I am trying to convert an UNIX timestamp to something PHP would like.
For example, I have this query.
SELECT Name, FROM_UNIXTIME(UNIX_TIMESTAMP(Date_of_birth),'%d.%m.%Y') As Date_of_Birth FROM Test
This should convert to "11.08.1964" however it converts to 01.01.1970
How do I convert UNIX timestamps to the date format d.m.Y inside a query?
I'm attaching my sample files and database.