Re: SQL question

Michael A. Peters wrote on 26/01/2010 06:04:

I use seconds from epoch in the database simply because it works so well with the php date() function. If you need something where Julian day really is better, I assume it isn't that hard to convert between posix and julian day, though it seems odd to me that it isn't part of the date() function. It probably should be.

When I do date comparisons in MySQL I use the to_days() function.

What I need to do is come up with a query that will determine if the start_date + no_donations falls within $start and $end.

In the given example one could determine that a month is always 30 days and then say to_days(start_date)+(no_donations*30) < to_days(end). This would however be a very loose method. You could go for finding the number of days in the current month and substract that (10th. = 30-10), play with MySQLs left() function But Skip, as the others say, use a date class, since you're passing a php var on to the SQL anyway, then you could determine the exact days from start to end of donation. Combine this with to_days and you have your solution -- Kind regards Kim Emax - masterminds.dk