Mark Kelly <pgsql(at)wastedtimes(dot)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