Hi Tom.
On Thursday 19 Nov 2009 at 00:37 Tom Lane wrote:
> Use to_char() for this sort of thing. Something like
> to_char(now(), 'HH24:MM') is probably what you want here.
Oh whoops. I just realised that was linked from the page I found extract() on.
Guess it's obvious now why I'm on the novice list :)
Thank you for taking the time to reply,
Mark