On Tue, Oct 05, 2004 at 10:00:29 -0500, Kevin Barnard <[EMAIL PROTECTED]> 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.
Won't that be a problem for times between 0000 and 0059?
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
