Lightwalker
asked on
Add a day to SQL FROM_UNIXTIME
Dear Experts,
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.Star
How can I add 1 day to the result?
Many thanks as always for your help
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.Star
How can I add 1 day to the result?
Many thanks as always for your help
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
You're welcome, glad to help.
PHP
PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.
125K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER