how to only use date not time in a calculation

matleeds

hi,

I have some code that deals with sending out reminders for appointments due the following day.

So if today is the 21/3 then only reminders for appointments due on the 22/3 should be sent.

Currently this isn't happening...

If reminders are sent on 21/3 at 9.50 am, my code adds 24 hours to this datetime and sends reminders due for all
appointments that fall bewteen 21/3 9.50am and 22/3 9.49 am.

What I want to do is simply send all reminders for appointments that are on the 22/3 exclusive of time.

I'm not sure how do this in php, which uses the unix datetime format to mildy complicate issues

anhy help or solutions would be massive, thanks.

$days = time() + (1 * (60 * 60 * 24));
$apts = $db->fetch_all('status = 1 AND time > ? AND time < ?', array(time(), $days));

Weedpacket

PHP has lots of functions for working with dates and times (that won't be thrown by the fact that not all days are 86400 seconds long).

E.g. (see [man]date[/man] and [man]strtotime[/man] for details),

$tomorrow = strtotime('tomorrow');
$day_after = strototime('+1 day', $tomorrow);
echo date('Y-m-d H:i:s', $tomorrow), "\n", date('Y-m-d H:i:s', $day_after);

So too should your DBMS, including possibly one that converts from Unix timestamps to its own native date/time type.

bradgrafelman

matleeds;10999533 wrote:
I'm not sure how do this in php, which uses the unix datetime format to mildy complicate issues

PHP itself doesn't strictly "use" any one format. There are a variety of date/time functions to work with a variety of formats of dates and times.

However, it would probably be easier to do everything in the SQL query itself, assuming your table was properly defined. For example, what type of column is the 'time' column?

Assuming it's a DATE/DATETIME/TIMESTAMP column, you could do something like:

WHERE DATE(time) = (CURDATE() + INTERVAL 1 DAY)