Going back to the documents I think Tom's answer of prepending FM is
better then mine. Look at table 9-22 for other options
On Tue, 5 Oct 2004 10:06:51 -0500, Todd P Marek <affe23@somahq.com> wrote:
>
>
>
> 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
>
>