[PHP-DB] Leap Year

2011-01-31 Thread Ron Piggott 

Does mySQL have the ability to figure out if it is leap year?  If so, what is 
the correct syntax for:

AND `day`  366 unless it is leap year
Ron

The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info

Re: [PHP-DB] Leap Year

2011-01-31 Thread Bastien Koert 
On Mon, Jan 31, 2011 at 8:06 AM, Ron Piggott
ron.pigg...@actsministries.org wrote:

 Does mySQL have the ability to figure out if it is leap year?  If so, what is 
 the correct syntax for:

 AND `day`  366 unless it is leap year
 Ron

 The Verse of the Day
 “Encouragement from God’s Word”
 http://www.TheVerseOfTheDay.info


http://www.phpclasses.org/package/3539-PHP-Check-whether-a-given-year-is-a-leap-year.html

http://www.freeopenbook.com/mysqlcookbook/mysqlckbk-CHP-5-SECT-28.html

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html

-- 

Bastien

Cat, the other other white meat

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php