mysql - count number of days between nextmonth and nextmonth +2days -


Find the number between COUNT numbers in the field created (next month (created date)

This mysql query query requires data for both date and datetime

EX:

Created Expirydate 2-01-2011 2-02-2011 3-04-2010 3- 02-2011

Number of results 1

MySQL is a TO_DAYS () function , Which will give you the number of days for dates after the year 1582. Two dates in the number of days

MySQL Date and Time DataMathic DATE_ADD) or Date + Interval 2 days This functionality can be changed to the desired date Can be used to find. See the manual

and the difference between one day and that day + interval 2 days is always 2 days according to the definition.

Comments