On Oct 5, 2004, at 10:00 AM, 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.
I wasn't even paying attention to the seconds. I was in fact talking
about the leading 0.
Thanks to everyone and apologies for my oversight of the seconds clause.
Todd Marek