I recently had a bit of a problem with an Oracle DATE value. En route to finding out more about it, HJR linked to an earlier article he wrote. Very fun stuff.