Annular Solar Eclipse Video

Albert Said it Best

• William Estep
• Qotd

Computers are incredibly fast, accurate, and stupid; humans are incredibly slow, inaccurate and brilliant; together they are powerful beyond imagination.

Albert Einstein

Bulky Swatch Blanket

• William Estep
• Knitting

I’ve started putting together the Bulky Swatch Blanket.

I plan to tile the swatches together somewhat randomly and use different colors for the connecting knitting bands. The swatches are various sizes, so I will keep it random and shoot for a Mondrian-style look. We’ll see how it goes 🙂

Common MySQL Queries

• William Estep
• Programming

I ran across this terrific resource, Common MySQL Queries.

Tons of great examples…for example:

Given a birthdate in @dob, here are two simple formulae for age in years:

Date_format( From_Days( To_Days(Curdate()) - To_Days(@dob) ), '%Y' ) + 0
Year(Curdate()) - Year(@dob) - ( Right(Curdate(),5) < Right(@dob,5) )

and here is one for age in years to two decimal places, ignoring day of month:

Round((((Year(now()) - Year(@dob)))*12 + (((Month(now()) - Month(@dob)))))/12, 2)

Enjoy!