Lots of great little PostgreSQL date tricks by @robconery

Using PostgreSQL to Handle Calendar Data Like a Freak - YouTube