Mysql date deacrease interval

[hewarslemani]

hello

please i need help about date in mysql , iam try do interval between two date and count the interval i want after 24 hours decrease the interval.

for example : datediff(‘2017-8-1’ , ‘2017-8-8’) ‘interval’ from participant;
result : 7

but i want the result decrease after 24 hours. i mean automatically updated.

[r937]

@hewarslemani

but i want the result decrease after 24 hours.

please explain more

[hewarslemani]

i mean the interval time automatically after 24 hour deacrease or the start date increase automatically when the interval time equal 0 give me a message.

[Quarind]

You can use this command:

SELECT TIMESTAMPDIFF(SECOND,'2007-12-30 12:01:01','2007-12-31 10:02:00'); 
-- result: 79259  the difference in seconds with the time.

24 hours = 86400 seconds
Just use bash script which convert diff 86400 and mysql output result and decrease what do you want.