[thelist] AJAX Tip

Jay Blanchard jblanchard at pocket.com
Wed Apr 5 08:37:10 CDT 2006


[snip]
> And yes, lightbox is not Web2.0 either :-)

Ahh, but is it Web 3.11 for Workgroups?
-- 
[/snip]

I thought it was WebXP Home Edition.

Caution: tips are owed.

<tip type="MySQL">
To get the number of days in a month use LAST_DAY in your query;

SELECT LAST_DAY('2003-02-05');
        -> '2003-02-28'
SELECT LAST_DAY('2004-02-05');
        -> '2004-02-29'
SELECT LAST_DAY('2004-01-01 01:01:01');
        -> '2004-01-31'
SELECT LAST_DAY('2003-03-32'); <---invalid date
        -> NULL

</tip>



More information about the thelist mailing list