Re: Padding time values from EXTRACT()

Mark Kelly <pgsql@wastedtimes.net> writes:
> If I use the following snippet

> EXTRACT (hour FROM timestamp) || ':' ||
> EXTRACT (minute FROM timestamp)
> AS this_time

Use to_char() for this sort of thing.  Something like
to_char(now(), 'HH24:MM') is probably what you want here.

            regards, tom lane