[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