Uncategorized

Oracle: How to get all the months between two dates

select distinct(last_day(to_date(td.end_date + 1 – rownum))) from all_objects ,(– this is just to easily substitute dates for the example… select to_date(’30-JAN-2010′) start_date ,to_date(’15-MAR-2011′) end_date FROM   DUAL  ) td where trunc(td.end_date + 1 – rownum,’MM’) >= trunc(td.start_date,’MM’) order by 1;  …

Triathlon training day on Sunday

The HumanRace WomenOnly Triathlon training day at Dorney Lake is on Sunday. I’ve been eagerly anticipating it since I signed up in December. It was really a way for me to feel like a triathlete again without actually signing up…

Wednesday Walks

1000 calories burned yesterday according to my Polar F6, at any rate. 1000! Man, it can easily add up. Each of my 20-odd minute cycles (I hope to get each way under 20 minutes soon!) burned about 250 calories then…

Having to rein it in

Last night, I was talking to DH about my workout plans for the week. When I told him I was going to cycle twice, run twice and wanted to go climbing on Friday, he gave me “that look”. I knew…

Back on the bike

So, I got a new bike through my work’s cycle to work scheme LAST YEAR and have only just started riding it. Yeah, yeah, I know. I’m a fair weather rider, for sure. The other thing is that I live…

Pee or get off the Pot

I fell off the wagon and regained 4 of my 7 lost lbs (which is actually still 8 lbs less than my highest recorded weight). I blame Christmas and my reaction to Psycho Neighbour and it’s taken me some effort…