[olug] OLUG - Omaha Linux User Group: Third Thursday (fwd)

Kent Tegels ktegels at gmail.com
Tue Sep 19 20:08:54 UTC 2006


Can't answer much of this, but I can give you a list of dates... as
long as you don't mind ISO8601 formatting and some XML. Here's the
list for 2006:

<dates><date>2006-01-19T00:00:00</date><date>2006-02-16T00:00:00</date><date>2006-03-16T00:00:00</date><date>2006-04-20T00:00:00</date><date>2006-05-18T00:00:00</date><date>2006-06-15T00:00:00</date><date>2006-07-20T00:00:00</date><date>2006-08-17T00:00:00</date><date>2006-09-21T00:00:00</date><date>2006-10-19T00:00:00</date><date>2006-11-16T00:00:00</date><date>2006-12-21T00:00:00</date>
</dates>

Here's 2007:

<dates><date>2007-01-18T00:00:00</date><date>2007-02-15T00:00:00</date><date>2007-03-15T00:00:00</date><date>2007-04-19T00:00:00</date><date>2007-05-17T00:00:00</date><date>2007-06-21T00:00:00</date><date>2007-07-19T00:00:00</date><date>2007-08-16T00:00:00</date><date>2007-09-20T00:00:00</date><date>2007-10-18T00:00:00</date><date>2007-11-15T00:00:00</date><date>2007-12-20T00:00:00</date>
</dates>

I'll be adding a post to my blog about the T-SQL query that gives me
this. I'd suspect that query would work with MySQL etc, or if your
using Perl, the venerable Date::Manip package should give you a hack
around.

Cheers,
Kent



More information about the OLUG mailing list