Re: Padding time values from EXTRACT() - Mailing list pgsql-novice

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