I have a MySQL query that is taking an epoch time and converting it into readable date and time.
This works fine but I need to add a day to it (24 hours or 86,400 seconds) but can not work out how I can do this.
Here is the SQL
SELECT FROM_UNIXTIME(Members.StartEpoch,'%%a %%D %%b %%Y') AS StartDate FROM Members WHERE MemberID = 1
How can I add 1 day to the result?
Many thanks as always for your help