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 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
