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 <[EMAIL PROTECTED]> 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 > > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
