Posted by Tyrone Slothrop on 12/19/05 16:40

On Mon, 19 Dec 2005 00:42:15 -0800, gerg <noemail@noemail.com> wrote:

>> In MySQL a date would be saved in the format yyyy-mm-dd and, if you
>> stored the value in that format, the query would be like:
>> SELECT * FROM table WHERE (birthdate >= CURRENT_DATE() OR birthdate <=
>> DATE_ADD(CURRENT_DATE(),INTERVAL 30 DAY);
>
>Tyrone, Thanks alot. I'm gonna give this a shot. So, the
>current_date() function will look for the format of yyy-mm-dd ? I'm
>actually inserting the birthdays in the mm-dd-yyyy format. Will this
>make a difference? I'm assuming it will, so I will alter the script to
>submit in the other format.
>
>The INTERVAL 30 DAY, is specifying to look out 30 days? I'm assuming
>changing this number will allow me to return different amount of days to
>go out? It seems like the main thing to make this work is how I submit
>the original birthday dates in the database. Thanks again tyrone!
>
>Greg

The DATE_ADD() SQL function allows you to look for dates in days,
months, or years.

The structure of the date value is very important so you are going to
have to watch the structure when saving the data. I usually use
select boxes (dropdowns) to select the month, day and year. When
saving, you can build the value:
$qy = "INSERT INTO table SET date =
\"".$_POST['year']."-".$_POST['month']."-".$_POST['day']."\"";

[Back to original message]