Hey, I didn't know "trim" is so flexible... cool !
Cheers,
Csaba.
On Tue, 2004-10-05 at 17:00, Kevin Barnard wrote:
> SELECT trim(leading '0' from to_char(now(), 'HH:MM AM'))
>
> I think is what you really want. This gets rid of the nasty leasing 0.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html